Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 13, 2014 at 12:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Oct 10, 2014 at 08:58 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.