• Cadavre

    Your query works. Is it the same as the one

    select (major_id),OBJECT_NAME(major_id),grantee_principal_id,permission_name,state_desc from sys.database_permissions

    where grantee_principal_id=0