On 6 Feb 2015 3:15 PM, David G Johnston wrote:
Felipe Gasper wrote
Hello,
Is there a way to temporarily suspend a user account?
I would prefer not to revoke login privileges since that will break
things that mine pg_users and pg_shadow.
I also am trying to find something that is completely reversible, so
something like setting connection limit to 0, which would lose a
potentially customized connection limit, doesn’t work.
We do this in MySQL by reversing the password hash then running FLUSH
PRIVILEGES; however, that doesn’t seem to work in PostgreSQL/pg_authid
as some sort of cache prevents this from taking effect.
Has anyone else solved this issue? Thank you!
Personally untested:
ALTER ROLE role_name VALID UNTIL 'timestamp' --i.e., set that to sometime in
the past
This doesn’t work, either, because it will clobber any custom expiration
time for the role …
-FG
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
