Might not do what you want, but I just change the password.
--
Mike Nolan--
On Fri, Feb 6, 2015 at 4:11 PM, Melvin Davidson <melvin6925@xxxxxxxxx> wrote:
Possibly,To disble:To enable
ALTER USER name RENAME TO xname;
ALTER USER xname RENAME TO name;
???--On Fri, Feb 6, 2015 at 3:57 PM, Felipe Gasper <felipe@xxxxxxxxxxxxxxxx> 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!
-Felipe Gasper
Houston, TX
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
