Parameters—Create Role Statement
This statement has the following parameters:
role_id
Specifies the user name to be created. Must be a valid object name that is unique among all role, group, and user identifier names in the installation.
If an invalid role identifier is specified, the DBMS Server returns an error but processes all valid role identifiers.
Role identifiers are stored in the iirole catalog of the iidbdb. For details about system catalogs, see the Ingres Database Administrator Guide.
with_option
Specifies one of the following password options:
nopassword
password = 'role_password'
role_password
Allows a user to change his password. In addition, users with the MAINTAIN_USERS privilege can change or remove any password. If role_password contains uppercase or special characters, enclose it in single quotes. Any blanks in the password are removed when the password is stored.
Limits: Role_password can be no longer than 24 characters
Default: Nopassword if the password clause is omitted.
To remove the password associated with role_id, specify nopassword.
To allow a user's password to be passed to an external authentication server for authentication, specify external_password.