Applying row-level security to crystal report instance

[Former Member]

Hi

we have created crystal reports based on sap r/3 data using open sql driver and imposed row level security and published to BOE.The user when opens report with view on demand can see the data which he is supposed to see.

Is it possible to schedule a single instance of the crystal report and then all the users access the instance and see the data that they are supposed to see.If not what is the other way out.

Thanks in advance.

Kamal

[Former Member · Accepted solution]

If you're still looking for an answer I would check out Publications in BOE XI R3. I have been told that Publications now leverage SAP authorizations to provide row level security when viewing instances.

Edited by: Mike Garrett on Jan 28, 2009 1:57 AM

[IngoH]

Hi,

you could use the Security Definition Editor (transaction /CRYSTAL/RLS) to define row level security on a table / field level. In that way viewing or scheduling will leverage your definitions.

Ingo

[Former Member]

Hi Ingo

We already have the definitions setup in the Crystal RLS Editor and its working fine for view on demand purpose but not for the generated instances.I guess i read somewhere this should work but it doesnt look good for us so far.

Regards

Kamal

[Former Member]

Hi Kamal,

For your assumption, if schedule the report with full user authentication, then this instance will contain real data, all the user who has right to view this instance will see all the data inside.

But I remember this is a function of publication profile in BOE system, it should solve your problem.

I will add more detail later on this.

Thanks,

Ricky

[Max_Fenz]

Hi,

I didn't try it so far

but I found this Link:

http://neverknewthat.wordpress.com/2007/11/06/row-level-security-trick-with-crystal-reports/

-> create Instance with full authorization

-> Join CR-Result with Customer-Table: User Authorization

Max