skip to main content
SQL statements : DCL statements : CREATE ROLE
 

CREATE ROLE

This statement creates a role, a set of privileges that can be granted to users or to other roles. You can use roles to administer database privileges. You can add privileges to a role and then grant the role to a user. The user can then enable the role and exercise the privileges granted by the role.
To support CREATE ROLE processing, the IP GETSUPPORT operation must return TRUE for IP_SUPPORT_CREATE_ROLE.
A role contains all privileges granted to the role and all privileges of other roles granted to it. A new role is initially empty. You add privileges to a role with the GRANT statement.

Syntax 

CREATE ROLE role

Examples

CREATE ROLE teller