SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_location_view  AS  SELECT     dbo.ca_location.*, dbo.ca_link_company_location.company_uuid AS company_uuid  FROM         dbo.ca_link_company_location RIGHT OUTER JOIN                        dbo.ca_location ON dbo.ca_link_company_location.location_uuid = dbo.ca_location.location_uuid  WHERE     (dbo.ca_location.parent_location_uuid IS NULL)  

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