CREATE    VIEW dbo.allorgloccomputers
        AS
        SELECT    dbo.ai_oldef_prop.userid,
            dbo.ai_oldef_prop.orgnm,
            dbo.ai_oldef_prop.office,
            dbo.ai_oldef_prop.hwsource,
            dbo.ai_oldef_prop.region,
            dbo.ai_hwdef_prop.hwname,
            dbo.ai_hwdef_prop.hwmfgr,
            dbo.ai_hwdef_prop.hwproctype,
            dbo.ai_hwdef_prop.hwuuid
        FROM    dbo.ai_hwdef_prop
            INNER JOIN
            dbo.ai_oldef_prop
            ON dbo.ai_hwdef_prop.hwuuid = dbo.ai_oldef_prop.hwuuid
        WHERE     ai_hwdef_prop.hwname != ''
GO
GRANT SELECT ON  [dbo].[allorgloccomputers] TO [aiadmin]
GRANT INSERT ON  [dbo].[allorgloccomputers] TO [aiadmin]
GRANT DELETE ON  [dbo].[allorgloccomputers] TO [aiadmin]
GRANT UPDATE ON  [dbo].[allorgloccomputers] TO [aiadmin]
GRANT SELECT ON  [dbo].[allorgloccomputers] TO [aipublic]
GO