Examples—Alter Role Statement
The following examples change the attributes associated with a role identifier:
1. Change the password for the role identifier, new_accounts, to eggbasket.
alter role new_accounts with
password = 'eggbasket';
2. Remove the password associated with the identifier, chk_inventory.
alter role chk_inventory with nopassword;