Disabling Roles

To disable all roles, use the SET ROLE NONE statement:

=> SET ROLE NONE;
=> SHOW ENABLED_ROLES;
     name      | setting
---------------+---------
 enabled roles |
(1 row)