topic Re: Restricting Table access in Application Development and Automation Discussions

Restricting Table access

Former Member — Mon, 12 Mar 2007 13:19:22 GMT

Hi All,

Is it posible to limit the SAP Table (SE11) access to the particular user i.e I want XYZ user can only display the table TSTC i dont want him to display other tables.

If yes, plz tell me how to restrict this.

Regards,

Amit

Re: Restricting Table access

Former Member — Mon, 12 Mar 2007 13:26:27 GMT

You have to craete a role and you can restrict it via the object S_DEVELOP

cheers,

-Sunil

Re: Restricting Table access

Former Member — Mon, 12 Mar 2007 13:42:21 GMT

Hi Amit,

If you want to give access to only one table i.e., TSTC, than you will have to create a Custom Transaction code using SE93.

SE11 would give you access to many other tables which is not a good security practise.

Hope it helps.

Please reward points if it is useful.

Thanks & Regards,

Santosh

Re: Restricting Table access

Former Member — Tue, 13 Mar 2007 07:47:52 GMT

Hi,

Use can use the transaction variant to give access to only one table . This transaction variant can be assigned a Transaction code which can be assigned to a role and the role can be assigend to the user for whom you want to give the display access . Using a transaction variant you can give access to just 1 table.

Regards,

Sowmya.

Re: Restricting Table access

Former Member — Tue, 13 Mar 2007 09:14:07 GMT

Hi Sowmya,

Thanx for responding to my queery....can u plz explain how to use transaction variant?

Regards,

Amit

Re: Restricting Table access

Former Member — Tue, 13 Mar 2007 09:38:15 GMT

Hi Amit

Use a T-code SHD0 to create a transaction variant for access the tables.

regards

Madhu

Re: Restricting Table access

Wolfgang_Janzen — Tue, 13 Mar 2007 09:58:44 GMT

Notice: you can combine this approach (using a variant transaction to limit access to a single table / view) with the approach described in SDN thread (using Database Views to define selection conditions - allowing to limit access on field level).

Regards, Wolfgang

Re: Restricting Table access

Former Member — Wed, 14 Mar 2007 14:27:40 GMT

Hi amit,

Try this way:

1) goto se93, give a unique name, say z_tstc

2)Enter SE11 into the transaction field and select the flag the ‘skip initial screen’ field:

3)On the lower portion of the screen, enter the following information:

Name of screen field: DATABROWSE-TABLENAME

Value: Enter the name of the table you want to browse with (in your case it is TSTC)

4)save it.

5) Now add the transaction z_tstc in th role, and assigh it to the user.

Now user will be have access to TSTC table.

Hope it helps.

Please award points if it is useful.

Thanks & Regards,

santosh

Re: Restricting Table access

Former Member — Wed, 14 Mar 2007 15:45:54 GMT

Hi,

you can achieve it by using S_TABU_DIS

hope it helps