CREATE  VIEW dbo.pubappca
        AS
        SELECT    swuuid
        FROM    ai_swdef_prop
            INNER JOIN ai_pubdef_prop
        ON    ai_swdef_prop.pubuuid = ai_pubdef_prop.pubuuid
        WHERE    pubname = 'Computer Associates International'
GO
GRANT SELECT ON  [dbo].[pubappca] TO [aiadmin]
GRANT INSERT ON  [dbo].[pubappca] TO [aiadmin]
GRANT DELETE ON  [dbo].[pubappca] TO [aiadmin]
GRANT UPDATE ON  [dbo].[pubappca] TO [aiadmin]
GRANT SELECT ON  [dbo].[pubappca] TO [aipublic]
GO