Skip to main content
For any one or more (or all) users and roles in the system, the following can be listed: In addition, permissions, roles, & resource groups will be listed recursively for the roles the specified users/roles have and the roles those roles have, etc. This allows the full set of permissions for a given user or role, both direct & inherited, to be viewed with one command.
SHOW SECURITY Syntax

​
Examples

To show the permissions, roles, resource groups, and default schema for user jsmith:
SHOW SECURITY FOR User Example
To show the permissions, roles, and resource groups for the analyst role:
SHOW SECURITY FOR Role Example
To show the permissions, roles, resource groups, and default schema for the anonymous user and the public role:
SHOW SECURITY FOR Multiple Users/Roles Example
To show all users & roles:
SHOW SECURITY FOR All Users/Roles Example