JMSM (10/1/2008)
I think that u don't understand my question.I've got one user that is dbo on 3 databases, db_datareader on another 3 databases and db_datawriter on more 5 databases.
What i need is one query that can report all databases that are allocated to one specific user and all privileges that is got on them.
Thanks and regards,
JMSM 😉
Actually I did understand your question, you just didn't ask the right question. Check out the links in my signature line. What you really wanted was all database roles for a specific user.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question