Melvin Davidson <melvin6...@gmail.com> 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 <fel...@felipegasper.com> 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@postgresql.org) > 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.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
