SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_sd_requests_view
AS
SELECT call_req.id as id, call_req.persid as persid, call_req.ref_num as ref_num, call_req.summary as summary, call_req.description as description, call_req.status as status, call_req.active_flag as active_flag, call_req.open_date as open_date, call_req.close_date as close_date, call_req.resolve_date as resolve_date, call_req.type as type, call_req.affected_rc as own_resource_uuid, call_req.incident_priority as incident_priority
FROM call_req

GO
GRANT SELECT ON  [dbo].[arg_sd_requests_view] TO [swcmadmin]
GRANT SELECT ON  [dbo].[arg_sd_requests_view] TO [uapmadmin]
GRANT SELECT ON  [dbo].[arg_sd_requests_view] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_sd_requests_view] TO [uapmbatch]
GRANT SELECT ON  [dbo].[arg_sd_requests_view] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_sd_requests_view] TO [uapmreporting]
GRANT SELECT ON  [dbo].[arg_sd_requests_view] TO [uapmreporting_group]
GO