To examine the effective permissions on an object for a user, connect as or impersonate the user and run with c as ( SELECT concat(quotename(schema_name(schema_id)),'.', quotename(name)) fn from sys.objects o where o.is_ms_shipped = 0 ) Select * from c cross apply fn_my_permissions(c.fn,'OBJECT') p where subentity_name = '' Note that there is an edge case that will cause an object not to appear in this view, which is when the user running the query lacks VIEW DEFINITION on the target object, which you can work around by listing the objects before impersonating the target user, eg DECLARE @objects table (fn nvarchar(255)) insert into @objects(fn) SELECT concat(quotename(schema_name(schema_id)),'.', quotename(name)) fn from sys.objects o where o.is_ms_shipped = 0 execute as user='someuser'; with c as ( SELECT * FROM @objects ) Select * from c cross apply fn_my_permissions(c.fn,'OBJECT') p where subentity_name = '' revert