Топ-100
 

Описания команд доступны в программе CerebroSQL

ALTER ROLE

RDBMS Type: Oracle
Topic

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;