cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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?

Thanks,

Rick

Accepted Solutions (1)

Accepted Solutions (1)

ted_ueda
Active Contributor
0 Kudos

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.

Sincerely,

Ted Ueda

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Thanks