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: