467,134 Members | 947 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,134 developers. It's quick & easy.

Raising events from sql server 2005

Hi Team,
I have a strange requirement where in which, the running asp.net application should know when the permission of the user in the DB has been changed. If that is changed then the session must expire automatically and shouldn't allow the user to go fwd.

I am thinking of a solution where in which we can raise an event from the SQL Server 2005 DB upon role change and there by handling the event in the ASP.NET C# program and expire the session.

Can anyone please throw some light on this on how to raise the .Net events from the sql server DB upon a change in DB happens.

Thanks,
Ram
Sep 16 '08 #1
  • viewed: 1529
Share:
1 Reply
ck9663
Expert 2GB
All I can think of is to keep track of the session through a table. Every time you access your APP, the first thing it will do is to check that table. That would mean you have to keep your session id somewhere and bring it your the app. Whenever there are changes on the permission, that table should be updated. You can also have a smalldatetime column to signify the last time the application was used. If the current date/time is longer than x minutes than the last access, you can expire the session as well.

Just a thought....

-- CK
Sep 16 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by serge calderara | last post: by
7 posts views Thread by cider123@hotmail.com | last post: by
reply views Thread by Joe Campbell | last post: by
4 posts views Thread by Dave A | last post: by
7 posts views Thread by Christian Cambier | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.