OR 11.2 | Create Role Statement

System Reference Summary > System Reference Summary > Statements > OpenROAD SQL Statements > Create Role Statement

Was this helpful?

Create Role Statement

Defines one or more role identifiers and their associated password. Role identifiers are used to associate permissions with applications. After the role identifiers are created and privileges have been granted to them, use them with the connect statement to associate those rights 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.

Syntax:

create role role_id {, role_id}
[with with_option {, with_option}];

Last modified date: 12/20/2023