Views [dbo].[usd_v_osim_targets_deleted]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:32:11 PM Sunday, December 05, 2010
Last Modified12:40:41 PM Sunday, December 05, 2010
Columns
Name
uuid
id
Permissions
TypeActionOwning Principal
GrantSelectams_group
GrantSelectca_itrm_group
GrantSelectca_itrm_group_ams
SQL Script
CREATE view usd_v_osim_targets_deleted(uuid, id)
as
select     c1.uuid,     /* uuid of the computer */
    c1.id
from  csm_object c1,
    csm_link l1, csm_object p1
where
    c1.class=102     and /* computer */
    c1.name = ''     and /* unnamed computer */

    l1.child=c1.id    and  /* link computer to parent */
    l1.parent=p1.id and
    p1.class=103    /* parent is bs */
GO
GRANT SELECT ON  [dbo].[usd_v_osim_targets_deleted] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_v_osim_targets_deleted] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_osim_targets_deleted] TO [ca_itrm_group_ams]
GO
Uses
Used By