CREATE ROLE
Purpose
Use this statement to create a role.
Prerequisite
You need to have the system privilege CREATE ROLE.
Syntax
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.