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