Топ-100
 
CerebroSQL

CREATE ROLE

RDBMS Type: Oracle

unnamed (2).png

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

Example

CREATE ROLE dw_manager;

CREATE ROLE dw_manager
IDENTIFIED BY warehouse;

CREATE ROLE warehouse_user IDENTIFIED GLOBALLY;

CREATE ROLE warehouse_user IDENTIFIED EXTERNALLY;