lock database

Hi all, How Do I make a lock exclusive in my database ??? Tanks in advanced -- F'bio Antunes Fanix Consultoria Ltda. Brasil - SP Sent via Deja.com http://www.deja.com/ Before you buy.

you could revoke connect privileges to everyone until you are finished with whatever. or you could write a script that removes privileges at the table level . or you could lock the tables you are working with with syntax like begin work; lock table tablename in exclusive mode; .... your stuff here commit work; hth fabioantunes@my-deja.com wrote: > Hi all, > > How Do I make a lock exclusive in my database ??? > > Tanks in advanced > > -- > Fábio Antunes > Fanix Consultoria Ltda. > Brasil - SP > > Sent via Deja.com http://www.deja.com/ > Before you buy.