CREATE view  appsetrust AS SELECT ai_swdef_prop.swname, ai_swdef_hwdef_rel.hwuuid FROM  ai_swdef_hwdef_rel INNER JOIN  ai_swdef_prop ON ai_swdef_hwdef_rel.swuuid = ai_swdef_prop.swuuid WHERE ai_swdef_prop.swname = 'eTrust Antivirus'
GO
GRANT SELECT ON  [dbo].[appsetrust] TO [aiadmin]
GRANT SELECT ON  [dbo].[appsetrust] TO [aipublic]
GO