Post reply

How can we extract the complete list of users for a database and whether they are active or not

  • February 17, 2010 at 9:20 am

    #156683

    How can we extract the complete list of users for a database and whether they are active or not in both sql server 2000 and 2005. I need this information for a audit purpose.

  • February 17, 2010 at 9:30 am

    #1120195

    You can start in the sys.syslogins view in SQL 2005 and above. If memory services me correctly, there was a syslogins table in SQL 2000. I do not have a SQL 2000 instance to verify

    There is all kinds of info in the system tables. Looks there for things like this

    Andrew SQLDBA

  • February 17, 2010 at 10:03 am

    #1120222

    There is a table called sysxlogins but that only gives the logins details.

    But, I need a query that gives me a complete list of users who connect to the database from various applications.

  • February 17, 2010 at 1:47 pm

    #1120436

    Would query sys.sysusers (2K5+) give you the answer you're looking for?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • February 18, 2010 at 3:38 am

    #1120758

    Hi, Thanks for your reply..

    sysusers only shows the local users but I want the details of users in the complete AD who are accessing the database and whether they are active or not..

  • February 18, 2010 at 5:50 am

    #1120833

    sys.dm_exec_sessions -- 2005

    sysprocesses -- 2000

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply