ShowSchemaPolicy



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')