CREATE ROLE

Purpose

Use this statement to create a role.

Prerequisite

You need to have the system privilege CREATE ROLE.

Syntax

create_role::=

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;