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