[dbo].[usd_compos]

(local) > mdb > Views > dbo.usd_compos

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:21 PM Monday, May 04, 2009

Columns

Name
objectid
version
id
os
msgCodeBase

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_compos as
select P.proc_os_uuid as objectid, 1 as version, P.proc_os_id as id, P.proc_os_name as os,
P.msg_code_base as msgCodeBase from ca_proc_os P
GO
GRANT SELECT ON  [dbo].[usd_compos] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_compos] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_compos] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[usd_compos] TO [upmuser_group]
GO

Uses

[dbo].[ca_proc_os]
dbo

Used By

[dbo].[usd_compos_id_allcltn]