January 25, 2005 at 4:09 am
Hi all,
I am new with SQL Server and my experience is mostly in Oracle. I am looking at setting up user profiles in SQL Server. In a particular instance we want to setup profiles where a particular user session needs to be automatically killed after 30 mins of login time.
I know of profiles in Oracle, but how does it work in SQL Server.
Thanks in advance.
Shahid.
January 25, 2005 at 5:54 am
AFAIK there is no "auto-kill" feature in SQL. To add users search BOL "user accounts, changing" as 1 example
Good Hunting!
AJ Ahrens
webmaster@kritter.net
January 25, 2005 at 9:43 am
Unfortunately, in BOL "user accounts, changing" only shows howto change a user account to service. Eventually I may have to write a procedure to select pid and logon time and kill the session. Does anybody have some code ready for something similar.
Thanks.
Shahid.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply