Restrict program access

[Former Member]

Hi Experts,

Is there is any way to assign the memory id for any custom program?

My req. is if user A executes ZABC program & at the same time if user B trying to execute the same program then user B will get an error message that "Currently user A is executing the program."

Can anybody will suggest me how to do that?

Regards,

Neha

[Former Member]

Read up on locking mechanism for database records and then be creative to apply something like that on porgrams.

Or.... search SDN. I'm pretty sure this question was asked many times before.

[former_member226519]

create a simple table with fields REPORT and UNAME

when the report starts read this table first.

if there is an entry for your report stop running the report.

if there is no entry write report and user name to that table.

at the end of your report delet the table entry.

[Former Member]

>

> create a simple table with fields REPORT and UNAME
> when the report starts read this table first.
> if there is an entry for your report stop running the report.
> if there is no entry write report and user name to that table.
> at the end of your report delet the table entry.

What does the user do if the program terminates abnormally (dumps) without deleting the entry?

Rob

[former_member226519]

if a report dumps you usually have more trouble than simply delete a table entry manually.

[Former Member]

>

> if a report dumps you usually have more trouble than simply delete a table entry manually.

Not necessarily - anyway, an entry in a custom table is the wrong way to approach this. SAP has a locking concept and I don't know of a better way to do this.

Rob

[ThomasZloch]

I've used lock object ES_PROG for the same purpose in the past.

Thomas

[Former Member]

if its about background processing its very easy to find out. (from tables like tbtco,tbtcp, v_op).

but if its foreground execution that also depends upon its an active session or not.. if active session then i have already explained in your other thread:

==>you have not closed that thread yet or the thread

if its about running at random cases .. then you need to store some flag in some z table or pass some value to some unused parameter values...

[Former Member]

Hi Prakash,

Actually that earlier thread still not solving my purpose. My req. is if A user executes the program then at the same time user B won't be able to execute the program.

User B will get message that "Currently program ZABC is used by user XYZ".

Thanks,

Neha

[Former Member]

Hi,

1. Try with SAP Standard function modules to lock and unlock the program.

2. If you want to maintain custom table, set a flag and update if the execution is successful. Otherwise rollback the updates.

Regards,

Shiva.

[Former Member]

neha,

that is what exactly i gave in the thread

the last write statement will happen if the tcode is running by some other user.. in place of that write statement you can put a error message or info message and exit the program