topic Re: Creating authorisation check for table row level security in Application Development and Automation Discussions

Creating authorisation check for table row level security

Former Member — Wed, 16 Sep 2009 08:19:59 GMT

Hi All,

I have created a table maintenance program which as the following keys:

Sales Area

Sales Org

Company Code

Now we want to let users maintain data in this table but for some users I want to give access for some sales areas and some sales org and some company codes.

How can I create a authorisation or authority check to let users maintain data only to sales org or sales areas that a user is assigned. Also we want some users to only display the data some to maintain. How can I set this kind of authorisation.

Appreciate your inputs and ideas to implement this.

Thanks

Karen

Re: Creating authorisation check for table row level security

Former Member — Fri, 18 Sep 2009 18:56:37 GMT

Have you considered the S_TABU_LIN optional object?

Re: Creating authorisation check for table row level security

mvoros — Sat, 19 Sep 2009 05:38:47 GMT

Hi,

if you can not solve your problem with authorization object suggested by Julian then you can try to use events for additional checks. You can assign ABAP routine to various events in maintenance view (Environment -> Modifications -> Events in Table maintenance generator). There is event 25 - Individual authorization checks. You can use it to do additional authorization checks. For example for your own authorization object.

Martin

Re: Creating authorisation check for table row level security

Former Member — Sat, 19 Sep 2009 07:07:32 GMT

That is a good point. I was a bit uncertain whether a view had been created, because Karren only said:

> I have created a table maintenance program

Perhaps if Karren would clarify a bit, and confirm that the other post in the WDA forum is not related...?

Cheers,

Julius

Re: Creating authorisation check for table row level security

Former Member — Fri, 25 Sep 2009 08:59:02 GMT

Hi Julius

I have built the WD4A maintenance program on top of the Z Table directly.

Thanks

Karen