CREATE ROLE

Create a new role in the system.

Description

Create a new role in the system.

After creating roles, you can grant object privileges to the role and then grant the role to other roles or individual users to enable access control security for objects in the system.

Syntax

> CREATE ROLE [IF NOT EXISTS] role [, role ] ...

Role names are case-sensitive within the current account. Mixed-case names and Unicode/CJK characters are preserved when MatrixOne checks whether a role already exists. CREATE ROLE IF NOT EXISTS only suppresses the duplicate-role error when the existing role name matches the requested name exactly.

Examples

> create role rolex;
Query OK, 0 rows affected (0.02 sec)