Views [dbo].[usm_vw_link_offering_ci]
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
offering_id
ci_uuid_char
ci_uuid
status
Permissions
TypeActionOwning Principal
GrantSelectusmgroup
SQL Script
create view usm_vw_link_offering_ci as
select offering_id,sys.fn_varbintohexsubstring(1,ci_uuid,1,0) as ci_uuid_char,ci_uuid,status
from usm_link_offering_ci
GO
GRANT SELECT ON  [dbo].[usm_vw_link_offering_ci] TO [usmgroup]
GO
Uses