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