ALTER ROLE role { NOT IDENTIFIED | IDENTIFIED { BY password | USING [ schema. ] package | EXTERNALLY | GLOBALLY } } ;
ALTER ROLE warehouse_user NOT IDENTIFIED; ALTER ROLE dw_manager IDENTIFIED BY data; ALTER ROLE dw_manager IDENTIFIED USING hr.admin;