Business View Row Level Security
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?