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;
