July 22, 2009 at 1:00 pm
I need to collect all logins and user database mappings. I looked at master and found login names and default database mappings but I don't see what databases the login is a user in. What I would really like is to have a query that gives login name user databases it has access to and the database role.
Is this possible?
Thanks
July 28, 2009 at 11:59 am
Hi,
Try with
sp_helplogins
sp_helpuser
July 28, 2009 at 3:39 pm
Thanks, I forgot about these.
July 28, 2009 at 3:54 pm
It's my pleasure
October 2, 2009 at 9:21 am
Hi, I have written some SQL in the past that might just give you what you are looking for this will outout to a file in C:\temp called Security_Report.txt.
File is attahced. Rename to .sql before running it.
MCITP SQL 2005, MCSA SQL 2012
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy