Needs to have database level Locking

[Former Member]

Hi

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...

[Former Member]

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

[Former Member]

Hi

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

[Former Member]

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.

[Former Member]

Thanks Actually i used Native SQL to lock temporarily.

Thanks.