CREATE view  View_Request AS SELECT call_req.*, srv_desc.sym service_type, sevrty.sym severity_num, urgncy.sym urgency_num, prob_ctg.sym category_name, net_res.resource_name asset, impact.sym impact_num, assignee.last_name assignee_lastname, assignee.first_name assignee_firstname, assignee.middle_name assignee_middlename, customer.last_name customer_lastname, customer.first_name customer_firstname, customer.middle_name customer_middlename, View_Group.last_name group_name, View_Group.contact_uuid groupID, cr_stat.sym status_name, pri.sym priority_num FROM (((((((((((  call_req inner join  pri ON call_req.priority = pri.enum) inner join  ca_contact customer ON call_req.customer =customer.contact_uuid) left join  srv_desc ON call_req.support_lev = srv_desc.code) left join  sevrty ON call_req.severity = sevrty.enum) left join  urgncy ON call_req.urgency = urgncy.enum) left join  impact ON call_req.impact = impact.enum) left join  ca_owned_resource net_res ON call_req.affected_rc = net_res.own_resource_uuid) left join  prob_ctg ON call_req.category = prob_ctg.persid) left join  View_Group ON call_req.group_id = View_Group.contact_uuid) left join  ca_contact assignee ON call_req.assignee = assignee.contact_uuid) left join  cr_stat ON call_req.status = cr_stat.code)
GO
GRANT SELECT ON  [dbo].[View_Request] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[View_Request] TO [service_desk_ro_group]
GO