Wednesday, November 9, 2011

Inclusive or Exclusive Row Security.. And the fight goes on!!

This is more like the Parry’s Coffee Bite Ad that we used to watch when we were kids… its toffee…its coffee. The only difference being rather than the candy that we enjoyed Row Security sometimes comes up as a nightmare.

The way ahead is much easier than what you may think of. If you are on 8.9 or higher release just go to the Form exit for Exclusive\Inclusive in the Security Workbench application (P00950) and you can see with your own two eyes what type of security is maintained in your system

If you are on my beloved ERP 8 just do it the old school way by running this query on your F00950:

Select * from sys7334.F00950 where FSUSER = ‘EXCLUSIVE’;

If a value turns up for the query it means you have inclusive security enabled in the system.

In case you are wondering about the meaning of both the security types and do not have access to GSC here are my two cents worth of idea:

Inclusive row security simply means that the value that the user can see are included in the from and thru values defined for him or his role.

Exclusive row security means that the values mentioned are excluded from the user’s view.

The select queries are generated based upon this security setup for the user by the jde middleware. Now I know what’s the real use of the middleware

No comments:

Post a Comment