[dbo].[usd_vq

[dbo].[usd_vq_target]

(local) > mdb > Views > dbo.usd_vq_target

Properties
Columns
Permissions
SQL Script
Uses

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

Columns

Name
lanname
objectid
dis_hw_uuid
agent_type

Permissions

Type	Action	Owning Principal
Grant	Select	ca_itrm_group
Grant	Select	ca_itrm_group_ams
Grant	Select	ams_group

SQL Script

/* ************************** 11613 end **************/
/* ************************** 11614 begin **************/

CREATE view usd_vq_target
as
select agent_name as lanname, object_uuid as objectid, NULL as dis_hw_uuid, agent_type
from ca_agent a
where a.agent_type = 1 or a.agent_type = 4
GO
GRANT SELECT ON  [dbo].[usd_vq_target] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_vq_target] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_vq_target] TO [ca_itrm_group_ams]
GO

Uses

[dbo].[ca_agent]
dbo