Skip to Content
avatar image
Former Member

Business View Security using Java for Crystal Reports XI R2 report prompt

Hi All,

I know that Business uses Role Level Security based up Folder/Object etc..

We need to take a little further so we created a table that needs to get validated for the location for the user.

I have written a Business View that uses Commands for Business View Prompt Information.

I need to enhance this command and interface a Java API Script that I pass it the user id and it then passes back the Locations that the users has access to or it passes back ALL this means that they have access to ALL Locations.

Any Suggestions on how to accomplish this?

Is this the right approach?



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 06, 2008 at 07:36 PM

    A Business View can be used to implement row-level security keyed to the Enterprise User, either explicitly for the User or indirectly for the UserGroup that the User is a member of.

    You appear to want greater selectivity for the row-level security.

    Unfortunately, there's no SDK control over the row-level security that would be secure.

    There's no direct control over Business Views or LOV via the SDK.


    Ted Ueda

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 08, 2008 at 04:51 PM

    I have proposed this same Question to our BODE user group and they suggested creating Oracle Views that do the Role Level Security.


    Add comment
    10|10000 characters needed characters exceeded