ORACLE: ALTER ROLE [EN]
top of page
CerebroSQL

Oracle:

ALTER ROLE

ALTER ROLE role
{ NOT IDENTIFIED
| IDENTIFIED
{ BY password
| USING [ schema. ] package
| EXTERNALLY
| GLOBALLY
}
} ;

example

ALTER ROLE warehouse_user NOT IDENTIFIED;

ALTER ROLE dw_manager
IDENTIFIED BY data;

ALTER ROLE dw_manager IDENTIFIED USING hr.admin;

bottom of page