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 😉