-
two copies of same user schema in one DB?
This may sound weird but:
I have a DB user called A, which owns a set of objects. Corresponding to it, I have a Java application that has many queries using A. when referencing to A's objects.
Another user is trying to use a copy of the Java application from his own development machine connecting to a "copy" of A's schema _in_the_same_DB_. So whatever changes he has made to his copy of A's schema via his own Java application won't affect the original person's A's schema.
Requirements:
- Both A and A's "copy" must be in the same DB
- Since the Java application has A. all over the place for SQL queries, we are reluctant to go through all the SQL statements to change A to some other DB user. That is, we don't want to change the Java application itself to have it point to a different user's schema which contains the same data as A's.
Is there a possible solution to this problem?
-
use alter session change current_schema
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|