CREATE view  hotfixdetailforcomputer AS
SELECT ai_hfdef_prop.hfpub, ai_hfdef_prop.hfname, ai_hfdef_prop.hfsp,
ai_hfdef_prop.hfid, ai_hfdef_prop.hfver, ai_hfdef_prop.hfrel, ai_hfdef_prop.hfmod,
ai_hfdef_prop.hfbld, ai_hfdef_hwdef_rel.hwuuid FROM  ai_hfdef_prop
LEFT JOIN  ai_hfdef_hwdef_rel ON ai_hfdef_prop.hfuuid = ai_hfdef_hwdef_rel.hfuuid
LEFT JOIN  ai_undef_hwdef_rel ON ai_hfdef_hwdef_rel.hwuuid = ai_undef_hwdef_rel.hwuuid
GO
GRANT SELECT ON  [dbo].[hotfixdetailforcomputer] TO [aiadmin]
GRANT INSERT ON  [dbo].[hotfixdetailforcomputer] TO [aiadmin]
GRANT DELETE ON  [dbo].[hotfixdetailforcomputer] TO [aiadmin]
GRANT UPDATE ON  [dbo].[hotfixdetailforcomputer] TO [aiadmin]
GRANT SELECT ON  [dbo].[hotfixdetailforcomputer] TO [aipublic]
GO