Rewriting sql queries depending on the source ip address

From: Chris Lever <af_inet_at_web.de>
Date: 12 Jul 2003 00:15:20 -0700
Message-ID: <1cea756d.0307112315.4d078efa@posting.google.com>

Hello,

I have 10 client machines which connect to 10 seperate Oracle servers. The name of the database on each server is db1. Now these Oracle servers should be consolidated and only one server for all databases should be used. But the database names in the clients are hardcoded. So i need a way to rewrite these database names dependending on the source ip address of the sql-query.

client1.company.com wants to use db1 -> connect to db1 on new server
client2.company.com wants to use db1 -> connect to db2 on new server
client3.company.com wants to use db1 -> connect to db3 on new server

Does anybody know a tool which can do this?

Thanks for your interest,
Chris Received on Sat Jul 12 2003 - 02:15:20 CDT