October 16, 2012 at 4:06 am
Hi,
I have situation where i need to prepare a report to find all the users and what access have they got to the databases in the server. So basically i need a login name and what are all the databases they can access to and what sort of permission they have on those databases. Can some one help me to get these information from system tables as i dont have much knowledge on them.
Regards,
Ram
October 17, 2012 at 6:48 am
See the following url for an Instance Security Audit script I wrote. Hope it helps.
http://qa.sqlservercentral.com/Forums/Topic1251262-146-1.aspx?Update=1
October 18, 2012 at 2:48 am
Thanks so much for your prompt response. l Really aprreciate it 🙂
October 18, 2012 at 4:41 pm
Wow! Awesome script. Thanks for sharing it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply