> I would prefer not to revoke login privileges since that will break things > that mine pg_users and pg_shadow. > Melvin Davidson-5 wrote >> Possibly, >> >> To disble: >> ALTER USER name RENAME TO xname; >> >> To enable >> ALTER USER xname RENAME TO name;
Given that removing login privileges is a no-go this doesn't seem like an acceptable solution for the OP. Its unclear exactly what catalog data is being used but likely the role name is an important one. David J. -- View this message in context: http://postgresql.nabble.com/Temporarily-suspend-a-user-account-tp5836978p5836987.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
