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 |
|
peace
Constraint Violating Yak Guru
420 Posts |
 Posted - 2012-03-12 : 04:49:40
|
| I have create a store proc and a report.There are paramater which is a list to select user name.If I login with my name and password, I could only view my name and my report.I cannot view other user report.Where should I apply this and how to do this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-12 : 10:12:02
|
| how are you passing username to report? is it taken automatically from User collection?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
peace
Constraint Violating Yak Guru
420 Posts |
Posted - 2012-03-12 : 21:18:18
|
| I apply it in store procedure.Select certain user.Is that possible to restrict this at the query?How can I query this? |
|
|
|
|
|
|
User's right