Locking a table in SM30 if table is accessed in another prog

Question: Hi Guys!

My problem is the following:

I have a standard table (WRF_BRANDS) that can be accessed through the transaction SM30. But I have to lock the table when it is being accessed by a program such that no user can modify the data through SM30.

Can someone please help?

Thanks in advance!

Mahesh
_________________
Mahesh

Answer:
Only way that comes to mind, create a new authorisation group, assign the table to that group and see that no one has a role that gives access to mentioned authorisation group, including no role with value * or &NC& in S_TABU_DIS, which should not be in any role anyhow!!!

Answer:
Do I understand correctly that SM30 maintenance is allowed, but not when your program is accessing or maintaining it?

If this is the case, then you don't have an authorization problem,
but a programming problem. SAP takes care of record-locking when
specific entries are being maintained; table locking would be an overkill...
If the program can't handle the manual maintenance, my guess is that
it is read into an internal table when started, changed there and copied
back into the database table... this is bad practice...

In this scenario, there is no solution...

If you want to disallow SM30 maintenance, change the SE11/SE13
settings to disallow manual table maintenance (checkbox in the
table definition screen)

No comments:

topics