GRANT role_name [, ...] TO ( user | USER user_mame | ROLE role_name) [, ...] [ GRANTED BY ( user | USER user | ROLE role | CURRENT_USER | CURRENT_ROLE ) ] [ WITH ADMIN OPTION ] [ IN catalog ]
Grants the specified role(s) to the specified principal(s).
WITH ADMIN OPTION clause is specified, the role(s) are granted
to the users with
GRANT statement for roles to succeed, the user executing it either should
be the role admin or should possess the
GRANT option for the given role.
GRANTED BY clause causes the role(s) to be granted with
the specified principal as a grantor. If the
GRANTED BY clause is not
specified, the roles are granted with the current user as a grantor.
IN catalog clause grants the roles in a catalog as opposed
to a system roles.
bar to user
GRANT bar TO USER foo;
foo to user
baz and role
qux with admin option
GRANT bar, foo TO USER baz, ROLE qux WITH ADMIN OPTION;
Some connectors do not support role management. See connector documentation for more details.