Show TOC

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

Use

The CREATE ROLE statement ( create_role_statement) defines a role.

Structure
				
<create_role_statement>::=
  CREATE ROLE <role_name> [IDENTIFIED BY <password>]
			

Examples

SQL Tutorial, Roles

Explanation

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.