Only a system security officer can add or drop a password from a role.
Use the alter role command to add or drop a password from either a system or user-defined role:
alter role role_name [add passwd password | drop passwd]
For example, to require the password “oper8x” for the oper_role, enter:
alter role oper_role add passwd oper8x
To drop the password from the role, enter:
alter role oper_role drop passwd
When you assign a password to a role, any user granted
the role must specify the password to Adaptive Server at the time
of activating the role.
