[dbo].[View_Contact_Full]
CREATE view View_Contact_Full AS SELECT ca_contact.*, ca_contact_type.name contact_type_name, loc.location_name location_name, org.org_name organization, admin.org_name admin_organization, srv_desc.sym service_type, loc.state state_sym FROM (((((( ca_contact left join ca_organization org ON ca_contact.organization_uuid = org.organization_uuid) left join ca_organization admin ON ca_contact.admin_organization_uuid = admin.organization_uuid)left join ca_location loc ON ca_contact.location_uuid = loc.location_uuid) left join ca_contact_type ON ca_contact.contact_type = ca_contact_type.id) left join usp_contact ON ca_contact.contact_uuid = usp_contact.contact_uuid) left join srv_desc ON usp_contact.c_service_type = srv_desc.code)
GO
GRANT SELECT ON [dbo].[View_Contact_Full] TO [service_desk_admin_group]
GRANT SELECT ON [dbo].[View_Contact_Full] TO [service_desk_ro_group]
GO
