Oracle in a Nutshell

Name

SET ROLE

Synopsis

SET ROLE {role [IDENTIFIED 

BY password] [,role [IDENTIFIED BY PASSWORD . . . ]] |
        ALL [EXCEPT role[, role . . . ]]
        NONE}

Enables one or more roles for a user or disables all roles for a user.

Keywords

ALL

Enables all roles granted to a user.

EXCEPT

Used to exclude some roles from being enabled with the ALL keyword.

NONE

Used to disable all roles for the user.