[dbo].[View_Group_to_Contact]
CREATE view View_Group_to_Contact AS SELECT View_Group.*, contact.first_name member_firstname, contact.middle_name member_middlename, contact.last_name member_lastname, grpmem.manager_flag grpmem_manager_flag FROM (( grpmem inner join View_Group ON grpmem.group_id = View_Group.contact_uuid) inner join ca_contact contact ON grpmem.member = contact.contact_uuid)
GO
GRANT SELECT ON [dbo].[View_Group_to_Contact] TO [service_desk_admin_group]
GRANT SELECT ON [dbo].[View_Group_to_Contact] TO [service_desk_ro_group]
GO
