How to provide controled sm30 access to a field in a customised table??

[Former Member]

Hi,

I recieved a request from our users to create a role which will give sm30 access to a particular field in a customised table.

I know we can restrict access to atable by using S_TABU_NAM authorization object, but not sure about how to restrict access to a particular field.

I tried S_TABU_LIN which is allowing to restrict to a whole cloumn in a table, but I am looking for single field.

Please post your suggestions and recommendations.

Thanks

Hari.

[Former Member]

Your easiest option is to get a developer to knock up a quick program that allows update that field only.  Granting access to SM30 to users is not usually a particularly good course of action.

[Former Member]

HI Alex,

Thank you for your response.

Is there any other way can we do this from basis side? instead of reaching Development team.

Thanks

Hari.

[niteshgupta87]

Hi Hari,

What do you mean by a "field"? A column is a field for a table. Using S_TABU_LIN object you can provide restriction for a column. Now create a role and put only the value which you want the user to be authorized for.

As Alex mentioned, do not give SM30 to users. It would be an audit violation, Instead of that, create custom tcode which will allow users to access only your custom table.

Regards,

Nitesh Gupta

[Former Member]

Hi All,

By using S_TABU_LIN and S_TABU_NAME, I am able to restrict SM30 access to a particular row in a table.

Thanks

Hari Duggineni