CREATE ROLE statement

Synopsis

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

Syntax Diagram

For information on reading syntax diagrams, see How to read syntax diagrams

Description

CREATE ROLE creates the specified role in the current catalog.

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 moderator WITH ADMIN USER bob;