Versions Compared

Old Version 70

changes.mady.by.user Wei Zheng

Saved on

compared with

New Version Current

changes.mady.by.user Wei Zheng

Saved on

Key

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

...

Code Block
languagetext
SHOW GRANT [principal_specification] ON (ALL | [TABLE] table_or_view_name);
 
principal_specification
  : 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.

...