SQL Guide : solidDB® SQL statements : CREATE ROLE
  
CREATE ROLE
CREATE ROLE role_name
Usage
The CREATE ROLE statement creates a new user role.
A role is a group of privileges that can be granted to users as one unit. You can create roles and assign users to certain roles. A single user may have more than one role assigned, and a single role may have more than one user assigned.
Notes
The same string cannot be used both as a user name and a role name.
Once a user role is granted, it takes effect when the user who is granted the role logs on to the database. If the user is already logged on to the database when the role is granted, the role takes effect when the user disconnects and then reconnects to the database.
solidDB® offers the following system roles. The system role names are reserved user names.
Reserved names
Description
PUBLIC
This role grants privileges to all users. When user privileges to a certain table are granted to the role PUBLIC, all current and future users have the specified user privileges to this table. This role is granted automatically to all users.
SYS_ADMIN_ROLE
This is the default role for the database administrator. This role has administration privileges to all tables, indexes and users, as well as the right to use solidDB® Remote Control. This is also the database creator role.
_SYSTEM
This is the schema name of all system tables and views.
SYS_CONSOLE_ROLE
This role has the right to use solidDB® Remote Control, but does not have other administration privileges.
SYS_SYNC_ADMIN_ROLE
This is the administrator role for data synchronization functions.
SYS_SYNC_REGISTER_ROLE
This role is only for registering and unregistering a replica database to the master.
Example
CREATE ROLE GUEST_USERS;
See also
solidDB® SQL statements