Query to return all users permissions on SQL Server

Hi everyone,

Please how can I use TSQL to get the list of all users detailed permissions and privileges on each database.

I want the query to return critieria like:

• Username
• Database name
• Login Type (SQL, Windows user or group, etc)
• Permission Type
• Permission State
• The specified object they have privileges on and they type of privileges.
• Roles (including the permission type, state and objects for each of the roles)

I need this information in a denormalized form if possible.

Thank you.