CREATE VIEW ca_am_agent_view as select engine_uuid as object_uuid, 3 as object_type, -1 as object_class, label from ca_engine union select dis_hw_uuid as object_uuid, 1 as object_type, class_id as object_class, label
from ca_discovered_hardware
union
select user_uuid as object_uuid, 2 as object_type, -1 as object_class, label
from ca_discovered_user
GO
GRANT SELECT ON [dbo].[ca_am_agent_view] TO [ams_group]
GRANT SELECT ON [dbo].[ca_am_agent_view] TO [ca_itrm_group]
GRANT SELECT ON [dbo].[ca_am_agent_view] TO [ca_itrm_group_ams]
GRANT SELECT ON [dbo].[ca_am_agent_view] TO [upmuser_group]
GO
[dbo].[ca_am_agent_view]