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