Топ-100
 

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

RDBMS Type: Oracle
Topic

SET ROLE
{ role [ IDENTIFIED BY password ]
[, role [ IDENTIFIED BY password ] ]...
| ALL [ EXCEPT role [, role ]... ]
| NONE
} ;

Example

SET ROLE dw_manager IDENTIFIED BY warehouse;

SET ROLE ALL;

SET ROLE ALL EXCEPT dw_manager;

SET ROLE NONE;