[dbo].[usm_vw_request]

(local) > mdb > Views > dbo.usm_vw_request

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
status
created_date
modified_date
completion_date
desired_date
comments
priority
req_for_account_id
req_by_account_id
req_for_user_id
req_by_user_id
code
domain
location_uuid

Permissions

Type	Action	Owning Principal
Grant	Select	usmgroup

SQL Script

create view usm_vw_request as
select request_id,name,status,created_date,modified_date,completion_date,desired_date,
     cast(comments as nvarchar) as comments,priority,req_for_account_id,req_by_account_id,
     req_for_user_id,req_by_user_id,code,domain,location_uuid
from usm_request
GO
GRANT SELECT ON  [dbo].[usm_vw_request] TO [usmgroup]
GO

Uses

[dbo].[usm_request]
dbo