Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
srahulmca
Starting Member
4 Posts |
 Posted - 2010-04-30 : 02:24:40
|
| Hi AllI have a requirement where i need to generate a list of users who can login into the sql server 2000 and what are all the database they can access and their roles. I got some information from this linkhttp://www.sqlservercentral.com/articles/Administration/listofdatabaseuserswithdatabaseroles/1545/After executing this I got a list of all users and their database access and roles. Then I realized something was missing. I used to login to sql server 2000 and execute sql statements. I am local system admin. I can see a login named Builtin\Administrator under security and this has access to all database as db_public and db_owner. But the above query didn't list the Builtin\AdministratorHere i have 2 questions1. Why is Builtin\administrators not listed ? doest that mean that the procedure and query given in the link is wrong.2. I can see certain users who has access to few of the databases. But these users are not in the login section under security. How can a user have access to database without a login ?I would be extremely thankfull to you could clarify my queries.ThanksRahul |
|
|
|
|
|
Sql server list of Logins, db access and Roles