Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abhit_kumar
Posting Yak Master
147 Posts |
 Posted - 2010-06-02 : 00:22:25
|
| Hello All,I have a requirement in report, such that if im login in SSRS through login id "vinit". Vinit is one of the employee of the company working in sales activities.Now there is one report there named "Sales Business Activities".There is different different selection paramter like,Branch, SBUHead,SalesEmployeeName,FromDate, ToDate.So curretly LoginID Vinit can able to access all the other department data also.For example if he select SalesEmployee "Ajay", he can see Ajay data too..I want to restrict "vinit" in such a way that he can access his data only not others.Is there any way or any other method to accomplish it?Please guide me its one of the major company threat.Regards,AKM |
|
|
|
|
|
Report Restriction through LoginID