Name
SET ROLE
Synopsis
SET ROLE {role
[IDENTIFIEDBY
password
][,role
[IDENTIFIED BYpassword
...]] | ALL [EXCEPTrole
[,role
...]] | NONE }
Enables or disables roles for the current session.
Keywords
- role
Name of the role to be enabled.
- IDENTIFIED BY
Specifies the password for the role. This option is required if the role is password protected.
- ALL
Specifies that all roles granted to you are to be enabled. If the EXCEPT clause is included, the specified roles will not be enabled, but all other roles granted to you will be.
- NONE
Specifies that all roles granted to you be disabled for this session.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.