Cacher is the code snippet organizer for pro developers

SELECT
	dpp.name,
	o.name,
	dp.*
FROM sys.database_permissions dp
LEFT OUTER JOIN sys.database_principals dpp
	ON dpp.principal_id = dp.grantee_principal_id
LEFT OUTER JOIN sys.objects o
	ON o.object_id = dp.major_id
WHERE dpp.name = 'OPWFTG\ZachNorman'