[dbo].[arg_asset_sd_view]
SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_asset_sd_view AS SELECT DISTINCT ca_owned_resource.own_resource_uuid as own_resource_uuid, 'nr:' + UPPER(dbo.hex(ca_owned_resource.own_resource_uuid)) as hex_own_resource_uuid FROM ca_owned_resource
GO
GRANT SELECT ON [dbo].[arg_asset_sd_view] TO [swcmadmin]
GRANT SELECT ON [dbo].[arg_asset_sd_view] TO [uapmadmin_group]
GRANT SELECT ON [dbo].[arg_asset_sd_view] TO [uapmbatch_group]
GRANT SELECT ON [dbo].[arg_asset_sd_view] TO [uapmreporting_group]
GO
