Thursday, January 17, 2013

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;

No comments: