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 some or all of the 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 some or all of the remaining roles within a session.