Views [dbo].[usd_iprocos]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:32:10 PM Sunday, December 05, 2010
Last Modified12:40:40 PM Sunday, December 05, 2010
Columns
Name
objectid
version
id
os
swdExtension
Permissions
TypeActionOwning Principal
GrantSelectams_group
GrantSelectca_itrm_group
GrantSelectca_itrm_group_ams
GrantSelectupmuser_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