LucidDbGrant

From Eigenpedia

Jump to: navigation, search

Syntax

GRANT ROLE unqualified-role-name, ...
TO unqualified-user-or-role-name, ...
[ WITH GRANT 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 HIERARCHY OPTION ]
[ WITH GRANT OPTION ]
[ GRANTED BY { CURRENT_ROLE | CURRENT_USER } ]
privileged-action ::=
{ INSERT | UPDATE | SELECT | DELETE | EXECUTE | USAGE }

Example

GRANT ROLE manager
TO vice_dba
WITH GRANT OPTION;
GRANT SELECT
ON warehouse.timesheet_fact
TO joe_bloggs;
Personal tools