From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
---|---|
To: | Gabriel Ramirez <gabriello(dot)ramirez(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: v8.3.4 metadata changes while users active |
Date: | 2012-04-05 03:17:01 |
Message-ID: | 0AD01C53605506449BA127FB8B99E5E10C368B92@FMSMSX105.amr.corp.intel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hmmmm... I don't have root access :-(
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Gabriel Ramirez
Sent: Wednesday, April 04, 2012 11:00 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] v8.3.4 metadata changes while users active
On 04/04/2012 09:26 PM, Gauthier, Dave wrote:
> v8.3.4 on linux
>
> Here's the problem...
>
> I need toboot them off and prevent them from getting back in so that I
> can make the changes, then re-enable them. There are 2 users, lets call
> them "selectuser" and "moduser" who have "select" and
> "select,insert,update,delete" respectively and a dozenor so tables, plus
> many stored procedures and functions. So I'm not sure revoke/grant is
> such a great idea because I think I'd have to grant the privs back to
> all those elements.
>
> Thanks fora ny ideas?
>
Well something along this can work
try this as root
iptables -I INPUT -m state --state NEW -m tcp -p tcp --dport 5432 -j DROP
boot ogff your users
make changes
iptables -D INPUT -m state --state NEW -m tcp -p tcp --dport 5432 -j DROP
regards,
Gabriel
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2012-04-05 03:23:04 | Re: v8.3.4 metadata changes while users active |
Previous Message | Gabriel Ramirez | 2012-04-05 02:59:54 | Re: v8.3.4 metadata changes while users active |