How to Provide Data and User Level Security to the Report?

[Ravi Kumar]

Hi all,

Here my Requirement is like as follows, 

    Data Security:

           who have the Permission to see the Report, can see their Data only

           (Here i am not Designing the Report for Each and Every User , it  is a common Report for every user but need to get the data which is Related to user only)

    Security ::

      Need some thing like if the user is Manager then he can able to see the data of the Reporties of that manager 

 

 

[ernst_2]

Hi Ravi Kumar,

I solved this problem with the LoggedInUsername parameter and some extra tables in the database, to manage the access over the sql-query.