---

{ “title”: “CREATE-ROLE”, “language”: “en” }

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