Row Level Security : CurrentCeUserName

building reports crystal reports
1

Hi,

We need to impose row level security in our reports but the filtering should happen at parameter level. The LOV’s for the offices should only be the offices the user has access to. I know this can be done in Business View but I don’t have access to it, if I need to create dynamic cascading parameters, I have to request it. So I don’t have any idea how it’s done. I’ve sent the BI guy a script to create the cascading prompt depending on CurrentCeUserName. I’m not sure if there’s something wrong with the syntax or if it has to be done some other way.

Here’s part of the where clause:

Upper(Z.USERNAME) = UPPER(CURRENTCEUSERNAME)

Please advise.

Thanks

sofia (BOB member since 2009-01-09)

2

Apply the row restriction set using @Variable(“BOUSER”).

Farhan Jaffery :us: (BOB member since 2005-08-27)

3

Thanks, but this is to be done in Business View not in the universe.

sofia (BOB member since 2009-01-09)