Топ-100
 

CREATE ROLE

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

RDBMS Type: Oracle
Topic

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;