Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


Code Block
SHOW GRANT [principal_specification] ON (ALL | [TABLE] table_or_view_name);
  : USER user
  | ROLE role

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.