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.
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).
- To temporarily prevent the user from logging in, run this command:
pguser=# alter user bob nologin;
- To let the user connect again, run the following...