If you drop a role while a member user is logged on, the user immediately loses the privileges granted to that role.
The user must use the SET ROLE statement to reactivate any remaining roles within a session.
If you drop a role while a member user is logged on, the user immediately loses the privileges granted to that role.
The user must use the SET ROLE statement to reactivate any remaining roles within a session.