SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_sd_issues_view
AS
SELECT issue.id as id, issue.persid as persid, issue.ref_num as ref_num, issue.summary as summary, issue.description as description, issue.status as status, issue.active_flag as active_flag, issue.start_date as start_date, issue.open_date as open_date, issue.close_date as close_date, issue.resolve_date as resolve_date, lrel.r_persid as own_resource_uuid
FROM issue, lrel WHERE issue.persid=lrel.l_persid and lrel.l_attr='asset'

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