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. The syntax is:
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
