CREATE    VIEW dbo.appsetrust
        AS
        SELECT    dbo.ai_swdef_prop.swname,
            dbo.ai_swdef_hwdef_rel.hwuuid
        FROM    dbo.ai_swdef_hwdef_rel
            INNER JOIN
            dbo.ai_swdef_prop
            ON dbo.ai_swdef_hwdef_rel.swuuid = dbo.ai_swdef_prop.swuuid
        WHERE    UPPER(dbo.ai_swdef_prop.swname) like '%ETRUST ANTIVIRUS%'
        
GO
GRANT SELECT ON  [dbo].[appsetrust] TO [aiadmin]
GRANT INSERT ON  [dbo].[appsetrust] TO [aiadmin]
GRANT DELETE ON  [dbo].[appsetrust] TO [aiadmin]
GRANT UPDATE ON  [dbo].[appsetrust] TO [aiadmin]
GRANT SELECT ON  [dbo].[appsetrust] TO [aipublic]
GO