Background documentationCREATE ROLE Statement (create_role_statement) Locate this document in the navigation structure


The CREATE ROLE statement (create_role_statement) defines a role.


Syntax Syntax

  1. <create_role_statement> ::=
      CREATE ROLE <role_name> [IDENTIFIED BY <password>]
End of the code.

SQL Tutorial, Roles


The current database user must be a database administrator (DBA user).

The role name must not be the same as the name of an existing role, database user, or user group.