Views [dbo].[arg_sd_requests_view]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:33:20 PM Thursday, February 10, 2011
Last Modified10:33:20 PM Thursday, February 10, 2011
Columns
Name
id
persid
ref_num
summary
description
status
active_flag
open_date
close_date
resolve_date
type
own_resource_uuid
incident_priority
Permissions
TypeActionOwning Principal
GrantSelectswcmadmin
SQL Script
CREATE VIEW dbo.arg_sd_requests_view
AS
SELECT call_req.id as id, call_req.persid as persid, call_req.ref_num as ref_num, call_req.summary as summary, call_req.description as description, call_req.status as status, call_req.active_flag as active_flag, call_req.open_date as open_date, call_req.close_date as close_date, call_req.resolve_date as resolve_date, call_req.type as type, call_req.affected_rc as own_resource_uuid, call_req.incident_priority as incident_priority
FROM call_req
GO
GRANT SELECT ON  [dbo].[arg_sd_requests_view] TO [swcmadmin]
GO
Uses