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