Re: Temporarily suspend a user account?

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

http://www.postgresql.org/docs/9.4/interactive/sql-alterrole.html

David J.

--
View this message in context: http://postgresql.nabble.com/Temporarily-suspend-a-user-account-tp5836978p5836982.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.