top of page
CerebroSQL

ALTER ROLE

RDBMS Type: Oracle

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