select RightAssignedOn='Group'
	, GroupName=saG.Name
	, saU.Name
	, case fr.RightID
		when 'e0598f66-511c-4088-9e77-3b6a36aef541' then 'Delete-DocLevel'
		when '43ed8510-1b61-498a-85eb-40d90135a855' then 'Delete-FileLevel'
		when '211af113-fac9-4ca6-8df4-4628ab3d791b' then 'Delete-FolderLevel'
		when 'ce123702-1227-4af7-8532-4826c1c7062e' then 'Delete-PageLevel'
		when '5c97fffd-b449-4524-8a3a-20f3d5f18eb1' then 'Delete-FileCalculateNote'
		when '6c91d47a-1c35-4719-8b2c-1b007a099a75' then 'Delete-FileNote'
		when '38a5d90a-c1e3-4ea0-86b5-662e78af4c04' then 'Delete-FolderCalculateNote'
		when '160d3b9a-f95e-46cc-b4cb-41e1345fe66e' then 'Delete-FolderNote'
		end as FunctionalityRight
	into #DeleteRightAssigments
from SecurityAccount saG
	join FunctionalityRights fr on fr.accountid = saG.accountid
		and fr.rightid in ('160d3b9a-f95e-46cc-b4cb-41e1345fe66e','211af113-fac9-4ca6-8df4-4628ab3d791b','38a5d90a-c1e3-4ea0-86b5-662e78af4c04','43ed8510-1b61-498a-85eb-40d90135a855','5c97fffd-b449-4524-8a3a-20f3d5f18eb1','6c91d47a-1c35-4719-8b2c-1b007a099a75','ce123702-1227-4af7-8532-4826c1c7062e','e0598f66-511c-4088-9e77-3b6a36aef541')
	join GroupMembers gm on gm.groupid = saG.accountid
	join SecurityAccount saU on saU.accountid = gm.accountid

insert into #DeleteRightAssigments
select RightAssignedOn='User'
	, GroupName=''
	, saG.Name
	, case fr.RightID
		when 'e0598f66-511c-4088-9e77-3b6a36aef541' then 'Delete-DocLevel'
		when '43ed8510-1b61-498a-85eb-40d90135a855' then 'Delete-FileLevel'
		when '211af113-fac9-4ca6-8df4-4628ab3d791b' then 'Delete-FolderLevel'
		when 'ce123702-1227-4af7-8532-4826c1c7062e' then 'Delete-PageLevel'
		when '5c97fffd-b449-4524-8a3a-20f3d5f18eb1' then 'Delete-FileCalculateNote'
		when '6c91d47a-1c35-4719-8b2c-1b007a099a75' then 'Delete-FileNote'
		when '38a5d90a-c1e3-4ea0-86b5-662e78af4c04' then 'Delete-FolderCalculateNote'
		when '160d3b9a-f95e-46cc-b4cb-41e1345fe66e' then 'Delete-FolderNote'
		end as FunctionalityRight
from SecurityAccount saG
	join FunctionalityRights fr on fr.accountid = saG.accountid
		and fr.rightid in ('160d3b9a-f95e-46cc-b4cb-41e1345fe66e','211af113-fac9-4ca6-8df4-4628ab3d791b','38a5d90a-c1e3-4ea0-86b5-662e78af4c04','43ed8510-1b61-498a-85eb-40d90135a855','5c97fffd-b449-4524-8a3a-20f3d5f18eb1','6c91d47a-1c35-4719-8b2c-1b007a099a75','ce123702-1227-4af7-8532-4826c1c7062e','e0598f66-511c-4088-9e77-3b6a36aef541')
		and saG.accounttype = 0