Views [dbo].[usm_vw_link_subscription_asset]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:19:34 AM Monday, December 13, 2010
Last Modified11:19:34 AM Monday, December 13, 2010
Columns
Name
request_id
request_item_id
asset_uuid_char
asset_uuid
Permissions
TypeActionOwning Principal
GrantSelectusmgroup
SQL Script
create view usm_vw_link_subscription_asset as
select request_id,request_item_id,
    sys.fn_varbintohexsubstring(1,usm_link_subscription_asset.asset_uuid,1,0) as asset_uuid_char,
    asset_uuid
from usm_link_subscription_asset
GO
GRANT SELECT ON  [dbo].[usm_vw_link_subscription_asset] TO [usmgroup]
GO
Uses