LucidDbGrant

Syntax

GRANT ROLE unqualified-role-name, ...
TO unqualified-user-or-role-name, ...
[ WITH ADMIN OPTION ]
[ GRANTED BY { CURRENT_ROLE | CURRENT_USER } ]

GRANT { ALL PRIVILEGES | privileged-action, ... }
ON [ TABLE | SPECIFIC { FUNCTION | PROCEDURE | ROUTINE } ] qualified-object-name
TO unqualified-user-or-role-name, ...
[ WITH GRANT OPTION ]
[ GRANTED BY { CURRENT_ROLE | CURRENT_USER } ]

privileged-action ::=
{ INSERT | UPDATE | SELECT | DELETE | EXECUTE | USAGE | REFERENCES }

Example

GRANT ROLE manager
TO vice_dba
WITH ADMIN OPTION;

GRANT SELECT
ON warehouse.timesheet_fact
TO joe_bloggs;