CREATE VIEW  dbo.pubappcacomputers
        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.allcomputers
            ON dbo.ai_swdef_hwdef_rel.hwuuid = dbo.allcomputers.hwuuid
            INNER JOIN dbo.ai_swdef_prop
            ON dbo.ai_swdef_hwdef_rel.swuuid = dbo.ai_swdef_prop.swuuid
            INNER JOIN dbo.ai_pubdef_prop
            ON  dbo.ai_swdef_prop.pubuuid = dbo.ai_pubdef_prop.pubuuid
            AND (pubname='Computer Associates International, Inc.' or pubname='Computer Associates International' or pubname='Computer Associates' or pubname='CA' or pubname='ca')
GO
GRANT SELECT ON  [dbo].[pubappcacomputers] TO [aiadmin]
GRANT INSERT ON  [dbo].[pubappcacomputers] TO [aiadmin]
GRANT DELETE ON  [dbo].[pubappcacomputers] TO [aiadmin]
GRANT UPDATE ON  [dbo].[pubappcacomputers] TO [aiadmin]
GRANT SELECT ON  [dbo].[pubappcacomputers] TO [aipublic]
GO