Results 1 to 5 of 5

Thread: How to write a query to view OS and db authenticated users ...

  1. #1
    Join Date
    May 2003
    Posts
    35

    How to write a query to view OS and db authenticated users ...

    Hi,

    we have a sqlserver 2000 db with a mixture of OS and NT authentication.How to write a query (or get info) on users.


    The query should be able to tell me that these users are OS authentiacted and these users are db authenticated.


    Thanks,
    -copernicus

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

  3. #3
    Join Date
    May 2003
    Posts
    35
    Hi Mak,

    Thanks for your reply I was wondering if there is a system table that I can query.


    thanks,
    -copernicus

  4. #4
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    select * from master.dbo.syslogins
    select * from sysusers on all databases for seeing users

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    Or sp_helplogins, avoid to query system tables directly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •