solidDB Help : solidDB reference : SQL: Statements : CREATE ROLE
  
CREATE ROLE
CREATE ROLE role‑name
Access requirements
SYS_ADMIN_ROLE role
Usage
Use the CREATE ROLE statement to create a new role that you assign to users by using the GRANT statement, see GRANT.
For more information including details of predefined system roles, see Authorization, privileges, and roles.
Notes
The same string cannot be used both as a user name and a role name.
After a user role is granted, the role 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.
Example
CREATE ROLE GUEST_USERS;
Go up to
SQL: Statements