3. Statements : OpenROAD SQL Statements : Create Role Statement
 
Share this page                  
Create Role Statement
The create role statement defines one or more role identifiers and their associated password. Role identifiers are used to associate privileges with applications. After the role identifiers are created and privileges have been granted to them, use them with the connect statement to associate those privileges with the session. For a discussion of role identifiers, see the Ingres Database Administrator Guide.
Only users who have been granted access to a role can use a role. The creator of a role is automatically granted access to that role.
This statement has the following syntax:
create role role_id {, role_id}
          [with with_option {, with_option}];