set roles

Some applications use the set role function within the application so the tables for a specific query can only be granted via the application.

However the set role function is all encommpassing, meaning that if an active role is not included in the set role function, then that current role will become non-current.

To test how a database session would work without roles, run : set role none;
this is very useful when testing how commands will work within procedures etc.