topic Re: Lock a table in Application Development and Automation Discussions

Lock a table

Former Member — Fri, 22 Jun 2007 11:16:48 GMT

I want to lock a table like mara..can u guys tell me how to lock.

Reg'

Zeemaaa...

Re: Lock a table

Former Member — Fri, 22 Jun 2007 12:07:32 GMT

What do you mean lock?

if you don't want people to see it then don't give anyone access to object S_TABU_DIS with auth group MA. This will also restrict access to any other tables in auth group MA. If this is a problem then you could change the auth group on the table.

Re: Lock a table

manohar_kappala2 — Fri, 22 Jun 2007 17:22:44 GMT

Hi,

Go to transaction SE11 and enter the table name and there in the Attributes tab

Unselect "Table maintainence allowed" This would avoid the capability to directly update table even if he has access to SE16 and Auth Grp corresponding to that particular table.

Second option is not giving access to SE16 and S_TABU_DIS with ACTVT 02

hope this helps

Manohar