14.5. CREATE ROLE
CREATE ROLE role_name [ WITH ADMIN ( user | USER user | ROLE role | CURRENT_USER | CURRENT_ROLE ) ] [ IN catalog ]
CREATE ROLE creates the specified role in
catalog or in the
current catalog if
catalog is not specified.
WITH ADMIN clause causes the role to be created with
the specified user as a role admin. A role admin has permission to drop
or grant a role. If the optional
WITH ADMIN clause is not
specified, the role is created with current user as admin.
CREATE ROLE admin;
moderator with admin
CREATE ROLE moderator WITH ADMIN USER bob;
foo in catalog
CREATE ROLE foo IN bar;
Some connectors do not support role management. See connector documentation for more details.