CREATE ROLE

Purpose

Use this statement to create a role.

Prerequisite

You need to have the system privilege CREATE ROLE.

Usage Notes

• A role possesses no privileges after the creation of it. Privileges are assigned with the GRANT statement. A role is either granted privileges directly or other roles are assigned to it.
• The same rules apply for role names as for user names. Refer to CREATE USER for more information.
• Rename a role by using the RENAME command.

• Information about the database roles can be found in the corresponding system tables, for example EXA_ALL_ROLES.

Example

CREATE ROLE test_role;