top of page
CerebroSQL

SET ROLE

RDBMS Type: Oracle

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;

bottom of page