CREATE VIEW apps
        AS
        SELECT    ai_swdef_prop.swname,
            ai_swdef_prop.swver,
            ai_swdef_prop.swrel,
            ai_swdef_prop.swmod,
            ai_swdef_prop.swnote,
            ai_swdef_hwdef_rel.hwuuid,
            ai_pubdef_prop.pubname
        FROM    ai_swdef_hwdef_rel
            INNER JOIN
            ai_swdef_prop
            ON ai_swdef_hwdef_rel.swuuid = ai_swdef_prop.swuuid
            INNER JOIN
            ai_pubdef_prop
            ON ai_swdef_prop.pubuuid = ai_pubdef_prop.pubuuid
GO
GRANT SELECT ON  [dbo].[apps] TO [aiadmin]
GRANT SELECT ON  [dbo].[apps] TO [aipublic]
GO