SQL Server user roles and permissions query

Question: Do you have a query that returns the user permissions for the database objects ?

Answer:  This query utilises the sys.database_principals view joined with the sys.database_permissions. 

The sys.database_principals returns a row for every security principal for a SQL Server database

The sys.database_permissions  returns a recordset of rows for every permission

SELECT  db_pri.name As USERNAME
,       db_pri.type_desc AS USER_TYPE
,       pmt.permission_name AS PERMISSION
,       pmt.state_desc AS PERMISSION_STATE
,       pmt.class_desc CLASS
,       object_name(pmt.major_id) AS [OBJECT_NAME]
FROM    sys.database_principals db_pri
LEFT JOIN
        sys.database_permissions pmt
ON      pmt.grantee_principal_id = db_pri.principal_id

read more on user permissions

How to Script SQL database role permissions and securables

Powershell sql server security audit - SQL Server DBA

SQL Database roles and members