Discussion Forum

hi experts,

In my project, we have many MIS reports which is been widely used by thousands of users. The current reports are designed in such a way that any user can view other user's data if they are coming in same hierarchy.

This has to be changed as, user A should see only his city data only, visa versa for user B also.

Is it possible to read their user name and generate query only for his city?

Or we need to implement BI authorizations?

kindly revert back to me ASAP.

jeeva

<Name is hidden> wrote:

 

Hi ,

As per your requirement, you can do as follows,

1. Make the info object as authorization relevant.( CITY )

2.create a authorization object using the info object and  restrict the city value.

3.Maintain the role and assign to the User who ever you want.

So the user from the city can get their values only.

Hope its helpful to you. ASAP.