SET ROLE

Purpose

This statement is used to activate the roles granted to the current login user in the current session.

Syntax

SET ROLE {
    DEFAULT
    | NONE
    | ALL
    | ALL EXCEPT role_name [, role_name ...]
    | role_name [, role_name ...]
};

Parameters

Examples

• Specify to activate all roles granted to the user in the current session, except for the role001 role.

  obclient [(none)]> SET ROLE ALL EXCEPT role001;
  

• Specify to activate the role001 and role002 roles of the user in the current session.

  obclient [(none)]> SET ROLE role001, role002;
  

References

• Activate a role
• View roles
• CURRENT_ROLE