[dbo].[usm_vw_request

[dbo].[usm_vw_request_value]

(local) > mdb > Views > dbo.usm_vw_request_value

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:14:49 AM Tuesday, March 30, 2010
Last Modified	11:14:49 AM Tuesday, March 30, 2010

Columns

Name
request_id
name
value
type
data_type
text_1

Permissions

Type	Action	Owning Principal
Grant	Select	usmgroup

SQL Script

create view usm_vw_request_value as
select request_id, name, cast(value as nvarchar) as value, type, data_type, text_1 from usm_request_value
GO
GRANT SELECT ON [dbo].[usm_vw_request_value] TO [usmgroup]
GO

Uses

[dbo].[usm_request_value]
dbo