Hmmmm... I don't have root access :-( -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Gabriel Ramirez Sent: Wednesday, April 04, 2012 11:00 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
