Temporarily preventing a user from connecting

Sometimes, you need to temporarily revoke a user's connection rights without actually deleting the user or changing the user's password. This recipe presents the ways of doing this.

Getting ready

To modify other users, you must either be a superuser or have the CREATEROLE privilege (in the latter case, only non-superuser roles can be altered).

How to do it...

1. To temporarily prevent the user from logging in, run this command:

pguser=# alter user bob nologin;
ALTER ROLE

2. To let the user connect again, run the following...