HOWTO setup user profiles

  • 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.

  • 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

  • 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