Versions Compared

Old Version 23

changes.mady.by.user Thejas Nair

Saved on

compared with

New Version 24

changes.mady.by.user Thejas Nair

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: documenting the sql compliant version of grant/revoke role. (Removing optional role keyword)

...

Code Block
languagetext
GRANT ROLE role_name [, role_name] ...
TO principal_specification [, principal_specification] ... 
[ WITH ADMIN OPTION ];

principal_specification
  : USER user
  | ROLE role

...

Code Block
languagetext
REVOKE ROLE role_name [, role_name] ...
FROM principal_specification [, principal_specification] ... ;

principal_specification
  : USER user
  | ROLE role

...