December 2002
Intermediate to advanced
928 pages
85h 29m
English
SET ROLE
SET ROLE
{ role [IDENTIFIED BY
password][,role [IDENTIFIED BY password ...]]
| ALL [EXCEPT role[,role ...]]
| NONE
}Enables or disables roles for the current session.
Name of the role to be enabled.
Specifies the password for the role. This option is required if the role is password protected.
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.
Specifies that all roles granted to you be disabled for this session.