17.5. CREATE ROLE

Synopsis

CREATE ROLE role_name
[ WITH ADMIN ( user | USER user | ROLE role | CURRENT_USER | CURRENT_ROLE ) ]
[ IN catalog ]

Description

CREATE ROLE creates the specified role in catalog or in the current catalog if catalog is not specified.

The optional 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.

Examples

Create role admin

CREATE ROLE admin;

Create role moderator with admin bob:

CREATE ROLE moderator WITH ADMIN USER bob;

Create role foo in catalog bar:

CREATE ROLE foo IN bar;

Limitations

Some connectors do not support role management. See connector documentation for more details.