Business View Row Level Security

[Former Member]

Hello,

I would like to create a Row Level Security in Business View. We are using a stored procedure to pull the data from database. We have manager and employee hierarchy. There are two fields such as Manager and Emplyee in the stored proc or when the data is pulled. We want to restrict data at wholesaler if wholesaler is loged on and manager if manager is loged on.

How can we do that? what filter should we apply? how can we pass on manager and wholesaler logon_Id to filter the rows in stored proc?

Does anyone have any answers?

[Former Member]

Good luck with this, this was one of my issues.

You can identify the user in Business View by using a seperate table that has the same information as BO XI R2 user name.

CurrentCEUserName is what I am using in Business View so that I can identify what location this user has access to.

And then I am creating an LOV filter on this information.

We are then prompting on this LOV in CR XI R2.

I have heard that it can be done in Stored Procedures but I am not sure what is involved.

Rick

[Former Member]

two questions still,

where do i find CurrentCEUserName? Is it a function within a Business view?

Also what is LOV?

I really appriciate your help. thank you so much.

sunil

[Former Member]

Yes CurrentCEUserName? is it a function within a Business View and Crystal Reports.

LOV stands for List of Values and it creates a prompt based up a value of a field.

[Former Member]

Thank you