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 one or more roles for a user or disables all roles for a user.
Enables all roles granted to a user.
Used to exclude some roles from being enabled with the ALL keyword.
Used to disable all roles for the user.