https://community.sap.com/t5/application-development-and-automation-discussions/database-table-protection-or-lock/m-p/13852455#M2030718 <P>Hello!</P><P>I need to protect a DB table from writing when my program in running. I have tried CF 'ENQUEUE_E_TABLE' and custom locks also, but these only work if the other programs do check the lock. If other programs start to insert/update/delete the table without checking the lock, they are executed with no errors or warnings. I tested it several times and checked in SM12 if the lock exists. So i need a solution to permanently protect the table from any writing, except the one that I executing.</P><P>Thanks in advance.</P> Tue, 03 Sep 2024 08:46:02 GMT mucsiattila 2024-09-03T08:46:02Z https://community.sap.com/t5/application-development-and-automation-discussions/database-table-protection-or-lock/m-p/13852455#M2030718 <P>Hello!</P><P>I need to protect a DB table from writing when my program in running. I have tried CF 'ENQUEUE_E_TABLE' and custom locks also, but these only work if the other programs do check the lock. If other programs start to insert/update/delete the table without checking the lock, they are executed with no errors or warnings. I tested it several times and checked in SM12 if the lock exists. So i need a solution to permanently protect the table from any writing, except the one that I executing.</P><P>Thanks in advance.</P> Tue, 03 Sep 2024 08:46:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table-protection-or-lock/m-p/13852455#M2030718 mucsiattila 2024-09-03T08:46:02Z https://community.sap.com/t5/application-development-and-automation-discussions/database-table-protection-or-lock/m-p/13852702#M2030720 <P>If those (dirty) programs don't use any SAP lock concept, then (alas) you have to lock data at database level.</P><UL><LI>Consider using&nbsp;<A href="https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/abenamdp_methods.htm" target="_self">AMDP - Methods</A>&nbsp;for&nbsp;<A href="https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/index.htm?file=abendb_lock.htm#@@ITOC@@ABENDB_LOCK_1" target="_self">Setting locks</A>.</LI><LI>You'll probably also need to use them to update records.</LI></UL><P>If there are not too many such programs, better correc those to use&nbsp;<A href="https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/abensap_lock.htm" target="_self">SAP Locks</A>&nbsp;</P> Tue, 03 Sep 2024 09:55:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table-protection-or-lock/m-p/13852702#M2030720 RaymondGiuseppi 2024-09-03T09:55:11Z