By user12587121 on Oct 17, 2011
My colleague Rene has some great postings explaining the importance of keeping an eye on entitlements that fall outside roles whilst developing an RBAC model and how to achieve that within OIA.
In this posting I just add another example report which will expose entitlements falling outside roles but this time formatted for use with BI Publisher. This will be useful to customers wishing to use BI Publisher as a reporting tool.
When loaded into BI Publisher the report will generate a listing by Business Unit, by Resource, by user for all the user's entitlements that fall outside the role model. You can specify a Business Unit and Resource as parameters to the report. This report will only include attributes flagged as minable to allow it to avoid including attributes that are unimportant from an entitlement point of view (like Firstname, for example).
The two BI Publisher files which define this report--the.xdo file which contains the SQL definition and the .rtf formatting file--are available here.