ShowSchemaPolicy

Table of Contents



Shows the security policy that applies to a schema: each permission, whether it is granted or denied, and the role and schema it was inherited from.

ShowSchemaPolicy(String schemaName)

Schema, Permission, Rule, InheritedFromRole and InheritedFromSchema.

round-pushpin Shows the policy for a schema.
EXEC ShowSchemaPolicy('WordList:Word')




Home
The home page
SQL :: Alter Procedure
User-defined stored procedures are not currently available.
SQL :: Cancel
Cancels (rolls back) the transaction of the given process, leaving the process connected.
SQL :: CheckpointHealthCounters
Writes the health counters to disk. This is useful when monitoring performance and you need the metrics in the health JSON file.
SQL :: ClearCacheAllocations
Empties the engine's memory cache. The memory is kept allocated for future cache use; call ReleaseCacheAllocations afterwards to return it to the operating system.
SQL :: ClearHealthCounters
Resets the health counters tracked by the engine. This is helpful when performance tuning.
SQL :: Exec
Exec runs a system procedure.
SQL :: Keywords
A breakdown of all of the statements and keywords supported by the query processor.
SQL :: Print
Evaluates an expression and returns the result as a message with the query results.
SQL :: RefreshMyRoles
Reloads the role memberships of the logged in account. Roles are cached at login, so run this after your memberships change instead of logging out and back in. The roles are returned as messages.