topic Re: restrict particular table in Application Development and Automation Discussions

restrict particular table

Former Member — Fri, 03 Aug 2007 11:58:37 GMT

hi,

how to restrict the particular table for to accessing particular user.

Re: restrict particular table

Former Member — Fri, 03 Aug 2007 12:05:01 GMT

This topic comes up weekly, there are detailed answers if you use the search function.

I'm sure a points seeker will copy and paste one of them for you soon.

Re: restrict particular table

Former Member — Fri, 03 Aug 2007 13:47:05 GMT

Check the values of authorization object S_TABU_DIS and the Tcodes to see tables (se16, 17, etc) for that particular user.

I hope helps,

Lean

Re: restrict particular table

manohar_kappala2 — Fri, 03 Aug 2007 13:56:40 GMT

Hi,

There are many scenarios to it, i am not sure as to which scenario ur situation falls into,

1)You can use S_TABU_DIS to give access to a table (based on SU53 or trace) along with Tcode through which he needs to access that table (example SE16 SM30 there are other parameter tcodes too).

But the catch here is that you would end up giving access to all the tables in that auth group.

2)If you want to give explicit access to a particular table and no other table then move that table to a new auth group(Can be done in SE54). however this approach might not be required in all cases as all the tables in that auth group might not be critical and sensitive.

3)Third option is to create a custom parameter transaction for SE16 with that table name and assign that tcode to the user

hope this helps

Manohar

Re: restrict particular table

Former Member — Tue, 07 Aug 2007 15:50:40 GMT

This has most likely already been answered, but to restrict table access you need to give that table a unique authorization group via SUCU or SM30 (tddat), then assign this unique value to S_TABU_DIS in a role the user is assigned to. I typically like to create table display roles per module using this method and only give users the handful of tables they really need to view, the auditors like this as well.

Re: restrict particular table

Former Member — Tue, 07 Aug 2007 15:56:34 GMT

I am sure this has been answered, but to restrict access to a table, you need to give that table a unique authorization group via SUCU or SM30 (TDDAT), then assign this value in S_TABU_DIS in a role the user is assigned to.