Re: out of locks is security breach

From: lbaltus@my-dejanews.com > >Our database uses row locking. >If i would create a table having more rows than there >are locks available on the system (easy!) and >I would delete these rows: > >delete from mytable> >(no transaction, no exclusive lock etc) >I would get an error saying somithing about the engine running >out of locks and the deleted rows will be rolledback in the table. > >OK. That's fine, but all other users and processes will experience the >same thing and even get error's, thats not fine. > >I think this is a bug, and if not it most certainly is a security breach: >I could criple any engine using row locking! > >Is there a way to prevent this from happening? I'm just guessing here, but have you tried adding more locks? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com