...
Code Block | ||
---|---|---|
| ||
SHOW ROLE GRANT (USER|ROLE) principal_name; |
Where where principal_name
is the name of a user or role.
...
Code Block | ||
---|---|---|
| ||
SHOW GRANT [principal_name] ON (ALL| ([TABLE] table_or_view_name) |
where principal_name
is the name of a user or role.
Currently any user can run this command. But this is likely to change in the future to allow users to see only their own privileges, and additional privileges would be needed to see privileges of other users.
...