SHOW SECURITY FOR User Syntax
Examples
To show the permissions, roles, resource group, and default schema for user jsmith:SHOW SECURITY FOR User Example
User Management
SHOW SECURITY FOR User
For any one or more (or all) users in the
system, the following can be listed:
In addition, permissions, roles, & resource groups will be listed recursively
for the roles the specified users have and the roles those roles have, etc.
This allows the full set of permissions for a given user, both direct &
inherited, to be viewed with one command.