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 |
|
lavvu
Starting Member
13 Posts |
 Posted - 2008-12-09 : 05:11:53
|
| Hi all,I have a scenerio. In my MOSS site I have deployed a report. I need to give access to the contents of these reports as per the person logged in into the site. For eg:If in my report I have ManagerID...............................ManagerName.......................DetailsX..............................................ABC........................................X1xxxxxxxxx..............................................................................................X2xxxxxxxxx..............................................................................................X3xxxxxxxxxY..............................................JKL.........................................Y1yyyyyyyyy..............................................................................................Y2yyyyyyyyy..............................................................................................Y3yyyyyyyyyZ..............................................STU.........................................Z1zzzzzzzzz...............................................................................................Z2zzzzzzzzz...............................................................................................Z3zzzzzzzzzIf Manager ABC is logged in to the MOSS site he should see only details X1,X2 and X3. and not the Y1,Y2,Y3,Z1,Z2 and Z3. Likewise if Manager JKL should see only details Y1,Y2 and Y3. Manager STU should see only Z!,Z2 and Z3. Is there any way to do this? Can anyone help me?Thanks in advance for the help. Love,Kannan. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-09 : 12:42:48
|
| what you can do is pass the username info of person who's viewing report to query/procedure and then retrieve only records relevant to him from tables by providing reqd permissions. also while calling sp you can use execute as optionhttp://msdn.microsoft.com/en-us/library/ms188354.aspx |
 |
|
|
lavvu
Starting Member
13 Posts |
Posted - 2008-12-10 : 01:23:20
|
Thank you. I did exactly that.  |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-10 : 02:59:27
|
| welcome |
|
|
|
|
|
|
Is role based secuirty possible in report data?