[dbo].[usm_vw_user_tenant

[dbo].[usm_vw_user_tenant_role]

(local) > mdb > Views > dbo.usm_vw_user_tenant_role

Properties
Columns
Permissions
SQL Script
Uses

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

Columns

Name
user_id
role_id
tenant_id
account_tenant_id

Permissions

Type	Action	Owning Principal
Grant	Delete	usmgroup
Grant	Insert	usmgroup
Grant	Select	usmgroup
Grant	Update	usmgroup

SQL Script

create view usm_vw_user_tenant_role as
select distinct * from dbo.usm_fn_get_user_tenant_role()
GO
GRANT SELECT ON  [dbo].[usm_vw_user_tenant_role] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_vw_user_tenant_role] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_vw_user_tenant_role] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_vw_user_tenant_role] TO [usmgroup]
GO

Uses

[dbo].[usm_fn_get_user_tenant_role]
dbo