Топ-100
 
CerebroSQL

ALTER ROLE

RDBMS Type: Oracle

unnamed (2).png

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;