17.31. SET ROLE
Synopsis
SET ROLE ( role | ALL | NONE ) [ IN catalog ]
Description
SET ROLE sets the enabled role for the current session in catalog
or in the current catalog if catalog is not specified.
SET ROLE role enables a single specified role for the current session.
For the SET ROLE role statement to succeed, the user executing it should
have a grant for the given role.
SET ROLE ALL enables all roles that the current user has been granted for the
current session.
SET ROLE NONE disables all the roles granted to the current user for the
current session.
Limitations
Some connectors do not support role management. See connector documentation for more details.