topic HOW CAN I LOCK MY DATABASE TABLE WITHOUT USING A PROGRAM? in Application Development and Automation Discussions

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

Former Member — Fri, 23 May 2008 06:43:56 GMT

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

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

Former Member — Fri, 23 May 2008 06:48:11 GMT

Hi,

Did you try using the authoriation group?

Shruthi

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

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

Former Member — Fri, 23 May 2008 06:50:19 GMT

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.

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

Former Member — Fri, 23 May 2008 06:50:45 GMT

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