> 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.