CREATE ROLE
Syntax
CREATE ROLE [IF NOT EXISTS] role_name
[WITH (createRoleOption [, ...])];
Description
Creates a new Custom Role within the Organization. Requires MANAGE_MEMBERS privilege.
Arguments
WITH (createRoleOption [, …])
Examples
Create a new Role
<no-db>/<no-store># USE ROLE useradmin;
+------------+------------+------------+------------------------+
| Type | Name | Command | Summary |
+============+============+============+========================+
| role | useradmin | USE | using role "useradmin" |
+------------+------------+------------+------------------------+
<no-db>/<no-store># CREATE ROLE IF NOT EXISTS new_role;
+------------+------------+------------+------------------------------------------+
| Type | Name | Command | Summary |
+============+============+============+==========================================+
| role | new_role | CREATE | role "new_role" was successfully created |
+------------+------------+------------+------------------------------------------+
Create a new Role under SysAdmin
<no-db>/<no-store># USE ROLE useradmin;
+------------+------------+------------+----------------------+
| Type | Name | Command | Summary |
+============+============+============+======================+
| role | useradmin | USE | using role useradmin |
+------------+------------+------------+----------------------+
<no-db>/<no-store># CREATE ROLE IF NOT EXISTS cust_role WITH (IN ROLE (sysadmin));
+------------+------------+------------+------------------------------------------+
| Type | Name | Command | Summary |
+============+============+============+==========================================+
| role | cust_role | CREATE | role "cust_role" was successfully |
| | | | created |
+------------+------------+------------+------------------------------------------+
Create a new Role under SysAdmin , adding new_role as a member
<no-db>/<no-store># USE ROLE useradmin;
+------------+------------+------------+----------------------+
| Type | Name | Command | Summary |
+============+============+============+======================+
| role | useradmin | USE | using role useradmin |
+------------+------------+------------+----------------------+
<no-db>/<no-store># CREATE ROLE IF NOT EXISTS test_role WITH (IN ROLE (sysadmin), ROLE (new_role));
+------------+------------+------------+------------------------------------------+
| Type | Name | Command | Summary |
+============+============+============+==========================================+
| role | test_role | CREATE | role "test_role" was successfully |
| | | | created |
+------------+------------+------------+------------------------------------------+
Last updated