SET QUOTED_IDENTIFIER OFF
GO
  CREATE VIEW dbo.arg_software_def_view AS  SELECT DISTINCT dbo.ca_company.company_name, swproduct.name AS product_name, swproduct.description as product_description,                         swrelease.name AS release_name, swproduct.manufacturer_uuid,                         swproduct.sw_def_uuid AS product_uuid, swrelease.sw_def_uuid AS release_uuid  FROM         dbo.ca_software_def AS swproduct LEFT OUTER JOIN                        dbo.ca_link_sw_def AS swlink ON swproduct.sw_def_uuid = swlink.primary_sw_def_uuid INNER JOIN                        dbo.ca_software_def AS swrelease ON swlink.secondary_sw_def_uuid = swrelease.sw_def_uuid FULL OUTER JOIN                        dbo.ca_company ON swproduct.manufacturer_uuid = dbo.ca_company.company_uuid  WHERE     (swproduct.software_type_id = 8) AND (swlink.link_type_id = 3)  

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