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 |
|
mwoolgar
Starting Member
11 Posts |
 Posted - 2006-05-18 : 04:42:53
|
| HiI need to make my reports secure so that when users log into the website they only see their reports. I have successfully implemented security for the website by passing the userid to the webpage. So on each page I have the following: SecurityHelper1.ValidateSession(this);SecurityHelper1.UserDetails.NameMy question is how do I pass the userid to the stored procedure... and where. Someone suggested something like this: convert.Toint32(SecurityHelper1.Userdetails.Name) but I'm not sure how correct this is or where I would place it.Many thanksWoolly |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-05-25 : 09:21:07
|
| You could add a hidden report parameter and pass the login in the url. |
 |
|
|
|
|
|
passing user id in a stored procedure