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