CREATE VIEW sys.server_principal_credentials AS
	SELECT indepid AS principal_id,
		depid AS credential_id
	FROM master.sys.sysmultiobjrefs
	WHERE class = 24 AND depsubid = 0 AND indepsubid = 0
		AND has_access('LG', indepid) = 1
	UNION	-- Adding results similar to sys.credentials view for creds added using WITH clause
	SELECT depid AS principal_id,
		indepid AS credential_id
	FROM master.sys.syssingleobjrefs
	WHERE class = 63 AND depsubid = 0 AND indepsubid = 0
		AND has_access('LG', depid) = 1