Views [dbo].[appsetrust]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:32:07 PM Sunday, December 05, 2010
Last Modified12:42:10 PM Sunday, December 05, 2010
Columns
Name
swname
hwuuid
Permissions
TypeActionOwning Principal
GrantSelectaiadmin
GrantSelectaipublic
SQL Script
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
Uses