The create_role operator creates a specified role. Available only in the Enterprise Edition.

Synopsis

create_role( 'roleName' )

Inputs

roleName: The name of the role to create, enclosed in single quotes.  The criteria for valid role names are the same as for valid usernames.  See create_user.

Summary

• A role is a binding between a set of users (the role membership) and a set of access rights (the role permissions).
• Each role may contain one or more users.
• Each role may contain access rights to one or more namespaces.
• The namespace access rights are: Create, List, Read, Update, and Delete.
• The create_role operator lets you create specified roles to which you can add users and access rights.
  
• Creating roles requires operator privileges.  However, the special roles admin and operator can only be created by the scidbadmin user.

Example

iquery --auth-file <root_login_authentication_file> "create_user('John', 'John_Password'); -- Create user John with password John_Password"
iquery --auth-file <root_login_authentication_file> "create_role('Engineering'); -- Create a new role called Engineering"
iquery --auth-file <root_login_authentication_file> "add_user_to_role('John', 'Engineering'); -- Add John to the role Engineering"
iquery --auth-file <root_login_authentication_file> "drop_user_from_role('John', 'Engineering');  -- Remove John from the role Engineering"
iquery --auth-file <root_login_authentication_file> "drop_role('Engineering');  -- Remove the role Engineering"
iquery --auth-file <root_login_authentication_file> "drop_user('John');  -- Remove the user John"