Query to produce login access report | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Query to produce login access report

Hi Everyone,<br /><br />Does anyone has experience or idea on how to build query on master system table(s) to produce login access report?<br /><br />In our organization, we need to review once a month who has access (SQL login, windows individual and group logins) to SQL server and what are their access level?<br /><br />Currently, I am doing it manually through enterprise manager in login list by checking one by one on every server of total 3 servers.<br /><br />I would appreciate any ideas or info. <br /><br />If no one has idea or experience on this, I plan to allocate my work time to research this, come with the query for this report and share it in our forum.<br /><br />I am thinking instead of reinventing the wheel may be faster to use what other(s) have already developed, or together we can come with ideas faster synergically than me by myself.<br /><br />Thank you for your attention and have a great day!<br /><br />[<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />][8D][<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />][<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Regards,<br /><br />Paulus
Which version of SQL you want to use? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
Hi Everyone,<br /><br />I use syslogins table in master database that has user default database access .That table has user info and their default database access. <br /><br />[<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />][<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Paulus