Views [dbo].[usm_vw_request]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:14:49 AM Tuesday, March 30, 2010
Last Modified11: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
TypeActionOwning Principal
GrantSelectusmgroup
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