Melvin Davidson <melvin6925@xxxxxxxxx> writes: > Possibly, > > To disble: > ALTER USER name RENAME TO xname; Fine if you don't care about losing password :-) yomamadb/postgres =# create user foo password 'foowow'; CREATE ROLE yomamadb/postgres =# alter user foo rename to fooxxx; NOTICE: MD5 password cleared because of role rename <<<--- ALTER ROLE yomamadb/postgres =# > > To enable > 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. [01] > -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@xxxxxxxxxxx p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
