-
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
-
-
Hi Mak,
Thanks for your reply I was wondering if there is a system table that I can query.
thanks,
-copernicus
-
select * from master.dbo.syslogins
select * from sysusers on all databases for seeing users
-
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
-
Forum Rules
|
|