[dbo].[usm_vw_catalog

[dbo].[usm_vw_catalog_tenant]

(local) > mdb > Views > dbo.usm_vw_catalog_tenant

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:19:34 AM Monday, December 13, 2010
Last Modified	11:19:34 AM Monday, December 13, 2010

Columns

Name
tenant_id
catalog_tenant_id

Permissions

Type	Action	Owning Principal
Grant	Select	usmgroup

SQL Script

/*
NOTE: the view is created using SQL object due to collate error in the mdb tool
*/
CREATE view usm_vw_catalog_tenant as
select tenant_id  COLLATE SQL_Latin1_General_CP1_CS_AS  as tenant_id,
dbo.usm_fn_get_catalog_tenant(tenant_id)  COLLATE SQL_Latin1_General_CP1_CS_AS  as catalog_tenant_id
from usm_tenant_ext
GO
GRANT SELECT ON  [dbo].[usm_vw_catalog_tenant] TO [usmgroup]
GO

Uses

[dbo].[usm_tenant_ext]
[dbo].[usm_fn_get_catalog_tenant]
dbo