MSSQL Select Grants.sql

SELECT
    permission.class_desc,
    permission.permission_name,
    permission.major_id,
    OBJECT_NAME(permission.major_id),
    permission.minor_id,
    permission.grantee_principal_id,
    principal.name
FROM sys.database_permissions permission
JOIN sys.database_principals principal ON permission.grantee_principal_id = principal.principal_id
WHERE principal.name = '{INSERT NAME}';