RE: Query/ Procedure to Generate list of logins and the DB access and their roles

SSC Guru

Points: 323504

April 30, 2010 at 6:33 am

i think it's due to the query; do a select * from sysusers in any database. there's no Builtin\Administrators in that list.

the query is not showing implicit users who have access regardless of whether you added them or not; those users like sa get access because they are sysadmins, they do not need to be added to each db's sysusers list. It's just getting explicitly granted users and their permissions.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!