CREATE    VIEW dbo.hotfixdetailforcomputer
        AS
        SELECT    dbo.ai_hfdef_prop.hfpub,
            dbo.ai_hfdef_prop.hfname,
            dbo.ai_hfdef_prop.hfsp,
            dbo.ai_hfdef_prop.hfid,
            dbo.ai_hfdef_prop.hfver,
            dbo.ai_hfdef_prop.hfrel,
            dbo.ai_hfdef_prop.hfmod,
            dbo.ai_hfdef_prop.hfbld,
            dbo.ai_hfdef_hwdef_rel.hwuuid
        FROM    dbo.ai_hfdef_prop
            INNER JOIN
            dbo.ai_hfdef_hwdef_rel
            ON dbo.ai_hfdef_prop.hfuuid = dbo.ai_hfdef_hwdef_rel.hfuuid
        
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