 |
|
|
 | DROP GROUP Statement |  | SQL Statements | DROP ROLE Statement |  |
statement_CREATE_ROLE ::= CREATE [ IF NOT EXISTS ] ROLE [ scheme. ] role_name
The CREATE ROLE statement creates a new role of the role_name name in the specified schema. If the schema is not set, the role is created in the current schema.
The maximum role name length is 31 characters. Roles in a schema must have unique names. Role_name may not begin with a number. If a role of the specified name already exists the error sqlstate 40004 (KEY_DUPLICITY) occurs.
| DROP GROUP Statement | | SQL Statements | DROP ROLE Statement | |