SQL Guide : Using SQL for database administration : Managing user privileges and roles : User roles
  
User roles
Privileges can also be granted to an entity called a 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.
Note:
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.
System roles
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.
See also
Managing user privileges and roles