Parameters—Alter Role Statement
This statement has the following parameters:
role_id
Specifies an existing role ID created with the create role statement. If one or more of the specified role identifiers do not exist, the DBMS Server issues a warning, but all valid role identifiers are processed.
For more information about role identifiers, see the Ingres Database Administrator Guide.
role_password
Defines the password for the role.
Caution! If no password is specified, any session has access to the specified role identifier and its associated permissions.
with_option
Specifies one of the following password options:
nopassword
password = 'role_password'