CREATE-ROLE

CREATE-ROLE

Name

CREATE ROLE

Description

The statement user creates a role

  CREATE ROLE role_name [comment];

This statement creates an unprivileged role, which can be subsequently granted with the GRANT command.

Example

1. Create a role

   CREATE ROLE role1;

2. Create a role with comment

   CREATE ROLE role2 COMMENT "this is my first role";

Keywords

 CREATE, ROLE

Best Practice