[dbo].[usd_iprocos]

(local) > mdb > Views > dbo.usd_iprocos

Properties
Columns
Permissions
SQL Script
Uses
Used By

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:12 AM Wednesday, March 07, 2007
Last Modified	6:12:22 PM Monday, May 04, 2009

Columns

Name
objectid
version
id
os
swdExtension

Permissions

Type	Action	Owning Principal
Grant	Select	ca_itrm_group
Grant	Select	upmuser_group
Grant	Select	ca_itrm_group_ams
Grant	Select	ams_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

[dbo].[ca_proc_os]
dbo

Used By

[dbo].[usd_procos_id_allcltn]