Views [dbo].[usd_vq_target]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:32:12 PM Sunday, December 05, 2010
Last Modified12:40:43 PM Sunday, December 05, 2010
Columns
Name
lanname
objectid
dis_hw_uuid
agent_type
Permissions
TypeActionOwning Principal
GrantSelectams_group
GrantSelectca_itrm_group
GrantSelectca_itrm_group_ams
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