Melvin Davidson <melvin6925@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 <felipe@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
connectionlimit 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âtseem 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.consulting@comcast.net
p: 312.241.7800