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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
