HOW CAN I LOCK MY DATABASE TABLE WITHOUT USING A PROGRAM?

[Former Member]

I am making a database table but i want that ONLY me can edit the table.

[Former Member]

Hi,

Did you try using the authoriation group?

Shruthi

Edited by: Shruthi R on May 23, 2008 8:48 AM

[Former Member]

Hi,

U can create a lock for your table by SE11:

Here u can create a lock object with the name has to begin with EZ*.This way two function modules will be created automatically, one for ENQUEUE and one for DEQUEUE.

To lock the table:

CALL FUNCTION 'ENQUEUE_E_TABLE'

EXPORTING

tabname = table_name

EXCEPTIONS

foreign_lock = 1

system_failure = 2

OTHERS = 3.

Do the required task

To Unlock the Table:

CALL FUNCTION 'DEQUEUE_E_TABLE'

EXPORTING

tabname = table_name

Here the table_name represents the table that you want to lock

Reward if useful.

Regards,

Swetha.

[Former Member]

Hi Rico,

Create a lock object with EXCLUSIVE LOCK mode for your DB table.

Hope this is helpful to you. If you need further information, revert back.

Reward all the helpful answers.

Regards

Nagaraj T