Activate and De-Activate Granted Roles

Check the roles that are enabled in your session:

select * from session_roles;

Using the command SET ROLE you can set only specific roles to active. Set all active:

set role all;

Disable specific roles:

set role all except role1, role2;