Views [dbo].[usd_iprocos]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:12 AM Wednesday, March 07, 2007
Last Modified6:12:22 PM Monday, May 04, 2009
Columns
Name
objectid
version
id
os
swdExtension
Permissions
TypeActionOwning Principal
GrantSelectca_itrm_group
GrantSelectupmuser_group
GrantSelectca_itrm_group_ams
GrantSelectams_group
SQL Script
CREATE view usd_iprocos as
select P.proc_os_uuid as objectid, 1 as version, P.proc_os_id as id, P.proc_os_name as os,
P.swd_extension as swdExtension from ca_proc_os P
GO
GRANT SELECT ON  [dbo].[usd_iprocos] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_iprocos] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_iprocos] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[usd_iprocos] TO [upmuser_group]
GO
Uses
Used By