CREATE VIEW "productidview" AS
       SELECT "productids"."productid"
       FROM "productids", "productkeyview"
       WHERE productids.productkey = productkeyview.product_key
GO
GRANT SELECT ON  [dbo].[productidview] TO [aionadmin_group]
GO