Skip to main content
Skip to main content

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​