CREATE    VIEW dbo.hotfixpubnmsphfcomputers
        AS
        SELECT    dbo.allcomputers.*,
            dbo.ai_hfdef_hwdef_rel.hfuuid
        FROM    dbo.allcomputers
            RIGHT OUTER JOIN
            dbo.ai_hfdef_hwdef_rel
            ON dbo.allcomputers.hwuuid = dbo.ai_hfdef_hwdef_rel.hwuuid
        WHERE    (dbo.allcomputers.hwname <> '')
        
GO
GRANT SELECT ON  [dbo].[hotfixpubnmsphfcomputers] TO [aiadmin]
GRANT INSERT ON  [dbo].[hotfixpubnmsphfcomputers] TO [aiadmin]
GRANT DELETE ON  [dbo].[hotfixpubnmsphfcomputers] TO [aiadmin]
GRANT UPDATE ON  [dbo].[hotfixpubnmsphfcomputers] TO [aiadmin]
GRANT SELECT ON  [dbo].[hotfixpubnmsphfcomputers] TO [aipublic]
GO