topic Re: Needs to have database level Locking in Application Development and Automation Discussions

Needs to have database level Locking

Former Member — Tue, 11 May 2010 11:38:48 GMT

I have table ZSTATUS having only 1 column STATUS. I want to lock this table at database level so that no-one can update it at database level unless i unlock it.

I used Enqueue & Dequeue functionality but tthat is only for application level and not for database level.

Thanks...

Re: Needs to have database level Locking

Former Member — Tue, 11 May 2010 11:53:41 GMT

Hi,

In se11 data base level you can set the field Data Browser/Table View Maint.display/maintenance not allowed

in delivery and maintenance tab

Re: Needs to have database level Locking

Former Member — Tue, 11 May 2010 15:10:05 GMT

Actually the solution u mentioned is not workable. i can change anything from TOAD (Sql server) from the mentioned table

I saw following useful link but also not workable.

http://www.sapdev.co.uk/dictionary/lock_enqueue.htm

Anyone have any idea how to lock a table at database level?

Thanks for your help

Re: Needs to have database level Locking

Former Member — Tue, 11 May 2010 19:18:16 GMT

Why not just go to the SQL level (Oracle, MS SQL) and lock it read-only from there? I wouldn't recommend it, but it would solve your problem.

Re: Needs to have database level Locking

Former Member — Tue, 11 May 2010 19:23:27 GMT

Thanks Actually i used Native SQL to lock temporarily.

Thanks.