mapping using SYNONYMs
I have the follwing situation: A vendor application running on the client side is using OCI and also .NET data provider.
The application is written such that it is using a fixed table owner prefix, name it VENDOR. So there exists a user VENDOR in the databse instance of
the Oracle server.
Now the requirement is brought to the vendor by one of his customers, to allow multiple schemata existing in parallel in one instance.
Since the name "VENDOR" can only be unique in one instance, I'm asking how it could be possibly mapped by using SYNONYMS.
I'm thinking of creating users (schema-owners) VENDOR001, VENDOR 002 etc., each one creating the schema under his name (VENDOR001,..002 etc.)