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
