Топ-100
 
CerebroSQL

SET ROLE

RDBMS Type: Oracle

unnamed (2).png

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;