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.

 All Forums
 Development Tools
 Reporting Services Development
 Accessing .Net session thru SQL Reports...

Author  Topic 

jim_cool
Starting Member

43 Posts

Posted - 2006-09-26 : 00:37:04
Hi all
I am working for application which is being developed in ASP .Net
The application also uses SQL Server 2005 Reporting Services.
Is there any way by which we can access .Net session object in sql reports?
ie.-i want to check which user has logged into the system ,so that i can only disply certain data to which user has access.
I just need to capture user id of that user.
Plz help me.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-09-26 : 04:46:10
you've provided too little information.

What kind of a session are you talking about?
what kind of usernames are we talking about?
sql server's users, windows users, your own users that are saved in a table in a database?




Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

jim_cool
Starting Member

43 Posts

Posted - 2006-09-26 : 11:53:41
I am talking about the users that r saved in database.
Actually my application uses the userid in order to determine if user has access to some functionality.
And i also want to access that same user id.
ASP .NET application uses session object for this purpose.
Is there any way by which i can acess that session.
Plz reply.
Go to Top of Page
   

- Advertisement -