Creates a new role. For more information, see Role-based access control.

​
Syntax

CREATE ROLE [ IF NOT EXISTS ] <role_name>

​
Parameters

ParameterDescription
<role_name>The name of the role.

​
Example

The following command will create a role “user_role” 
CREATE ROLE user_role;

​
Example 2

The following command will create a role “my_role_2” 
CREATE ROLE IF NOT EXISTS my_role_2
If “my_role_2” exists, no error message is thrown.