Temporarily preventing a user from connecting
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…
Follow these steps to temporarily prevent and reissue the logging-in capability to a user:
- To temporarily prevent the user from logging in, run this command:
pguser=# alter user bob nologin; ALTER ROLE
- To let the user connect again, run the following command:
pguser=# alter user bob login; ALTER ROLE
How it works...
Here are some additional remarks.