CREATE VIEW  dbo.pubappcamachines
        AS
        SELECT    DISTINCT hwuuid
        FROM    ai_swdef_hwdef_rel
            INNER JOIN pubappca
        ON    ai_swdef_hwdef_rel.swuuid = pubappca.swuuid
        GROUP
        BY    ai_swdef_hwdef_rel.hwuuid
GO
GRANT SELECT ON  [dbo].[pubappcamachines] TO [aiadmin]
GRANT INSERT ON  [dbo].[pubappcamachines] TO [aiadmin]
GRANT DELETE ON  [dbo].[pubappcamachines] TO [aiadmin]
GRANT UPDATE ON  [dbo].[pubappcamachines] TO [aiadmin]
GRANT SELECT ON  [dbo].[pubappcamachines] TO [aipublic]
GO