v8.3.4 on linux

Here's the problem...
I have to make some metadata changes, add columns to a table, add constraints, 
drop a view, recreate it.  I used to be able to do this by booting users off, 
and then quickly make the changes before they get back in.  They now have 
software that seems to connect immediately upon detecting loss of connection, 
so there's no more time wiondow for this old method to work.  The idea of doing 
this in a transaction doesn't seem to work.  It just sits there, the users stay 
connected.

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?




Reply via email to