[dbo].[View_Change_Act_Log]
CREATE view View_Change_Act_Log AS SELECT chgalg.*, View_Contact_Full.last_name analyst_lastname, View_Contact_Full.first_name analyst_firstname, View_Contact_Full.middle_name analyst_middlename, chgalg.last_mod_dt chgalg_last_mod_dt, act_type.sym activity_type FROM (( chgalg inner join act_type ON chgalg.type = act_type.code) left join View_Contact_Full ON chgalg.analyst = View_Contact_Full.contact_uuid)
GO
GRANT SELECT ON [dbo].[View_Change_Act_Log] TO [service_desk_admin_group]
GRANT SELECT ON [dbo].[View_Change_Act_Log] TO [service_desk_ro_group]
GO
