From: | Michael Nolan <htfoot(at)gmail(dot)com> |
---|---|
To: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
Cc: | Felipe Gasper <felipe(at)felipegasper(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Temporarily suspend a user account? |
Date: | 2015-02-06 21:20:53 |
Message-ID: | CAOzAqu+AbOe_AWAJX2FipBn97T87G3YozRJPXqB8yQfA1QABug@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Might not do what you want, but I just change the password.
--
Mike Nolan
On Fri, Feb 6, 2015 at 4:11 PM, Melvin Davidson <melvin6925(at)gmail(dot)com>
wrote:
> Possibly,
>
> To disble:
> ALTER USER name RENAME TO xname;
>
> To enable
> ALTER USER xname RENAME TO name;
>
> ???
>
>
> On Fri, Feb 6, 2015 at 3:57 PM, Felipe Gasper <felipe(at)felipegasper(dot)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 connection limit 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’t seem 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(at)postgresql(dot)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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | David G Johnston | 2015-02-06 21:24:53 | Re: Temporarily suspend a user account? |
Previous Message | David G Johnston | 2015-02-06 21:18:12 | Re: Temporarily suspend a user account? |