CREATE VIEW dbo.pubappcomputers
        AS
        SELECT    dbo.ai_swdef_hwdef_rel.swuuid,
            dbo.ai_swdef_prop.swname, swver, swrel, swmod, swbld, swnote,
            dbo.allcomputers.*,
            dbo.ai_pubdef_prop.pubname as swpub
        FROM    dbo.ai_swdef_hwdef_rel
            INNER JOIN dbo.ai_swdef_prop
            ON dbo.ai_swdef_hwdef_rel.swuuid = dbo.ai_swdef_prop.swuuid
            INNER JOIN dbo.allcomputers
            ON dbo.ai_swdef_hwdef_rel.hwuuid = dbo.allcomputers.hwuuid
            INNER JOIN dbo.ai_pubdef_prop
            ON dbo.ai_swdef_prop.pubuuid = dbo.ai_pubdef_prop.pubuuid
GO
GRANT SELECT ON  [dbo].[pubappcomputers] TO [aiadmin]
GRANT INSERT ON  [dbo].[pubappcomputers] TO [aiadmin]
GRANT DELETE ON  [dbo].[pubappcomputers] TO [aiadmin]
GRANT UPDATE ON  [dbo].[pubappcomputers] TO [aiadmin]
GRANT SELECT ON  [dbo].[pubappcomputers] TO [aipublic]
GO