SET ROLE
SET ROLE {role
[IDENTIFIED BYpassword
][,role
[IDENTIFIED BYpassword
...] | ALL [EXCEPTrole
[,role
...] | NONE }
Enables or disables roles (role) for the current session.
Specifies thepassword for the role. This 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 enabled.
Specifies that all roles granted to you are to be disabled for this session.