Skip to Content
avatar image
Former Member

Can we manually lock a program and workprocess and a table?

Can we manually lock a program and workprocess and a table?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Aug 18, 2007 at 01:38 PM

    You can "lock" transaction but not programs.

    Give me an example why you want to "lock" workprocess or a table, I donĀ“t see any real use of that...

    --

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • The only possibility I see is to mark the table as read only on database level or to revoke the connecting user the permission to write data to that table.

      However, that procedure is not common and one should rather use permissions in the SAP system to handle such things.

      --

      Markus

  • avatar image
    Former Member
    Aug 21, 2007 at 09:52 AM

    Oracle tables can be locked exclusively by using "lock table ... in exclusive mode". This is sometimes used e.g. in SAP BW systems. The lock is released when the next COMMIT or ROLLBACK takes place.

    Add comment
    10|10000 characters needed characters exceeded