Re: Temporarily suspend a user account?

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Temporarily suspend a user account?
Date: 2015-02-06 21:18:12
Message-ID: 1423257492415-5836987.post@n5.nabble.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Nolan 2015-02-06 21:20:53 Re: Temporarily suspend a user account?
Previous Message David G Johnston 2015-02-06 21:15:41 Re: Temporarily suspend a user account?