SET QUOTED_IDENTIFIER OFF
GO
Create VIEW dbo.arg_eventnotification_def_view AS SELECT DISTINCT                         dbo.arg_evdefhdr.evid, dbo.arg_evdefhdr.evname, dbo.arg_evdefhdr.evenable, dbo.arg_evdefhdr.evaction, dbo.arg_evdefhdr.evntfreq,                         dbo.arg_evdefhdr.evdef, dbo.arg_evdefhdr.table_name, dbo.arg_evdefhdr.field_name, dbo.arg_evdefhdr.evfrdef, dbo.arg_evdefhdr.evfrtext,                         dbo.arg_evdefhdr.evtodef, dbo.arg_evdefhdr.evtotext, dbo.arg_evdefhdr.evfirst, dbo.arg_evdefhdr.evconfrm, dbo.arg_evdefny.enid,                         dbo.arg_evdefny.enenable, dbo.arg_evdefny.entype, dbo.arg_evdefny.enrtype, dbo.arg_evdefny.enrecip, dbo.arg_evdefny.contact_uuid,                         dbo.arg_evdefny.endaysa, dbo.arg_evdefny.entext, astr.slvalue1 AS enable  FROM         dbo.arg_evdefhdr INNER JOIN                        dbo.arg_evdefny ON dbo.arg_evdefhdr.evid = dbo.arg_evdefny.enevid INNER JOIN                        dbo.arg_strlst astr ON astr.slentry = dbo.arg_evdefhdr.evenable AND astr.slid = 10  

GO
GRANT SELECT ON  [dbo].[arg_eventnotification_def_view] TO [swcmadmin]
GRANT SELECT ON  [dbo].[arg_eventnotification_def_view] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_eventnotification_def_view] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_eventnotification_def_view] TO [uapmreporting_group]
GO