Using Oracle I am trying to setup a set of tables belonging to a
particular application twice within a single database instance for
two different groups of people. Both groups of people must use the
same application SQL code, but with different data.
(If I were using Sybase I would just create two databases with the
same tables and then create user accounts with the default database
set appropriately.)
I do not want the SQL (&PL/SQL) application code to prefix table
references with a schema name. (i.e. both groups use the same
application code.)
Within each user group there needs to be one Oracle account that
creates the tables etc.
The rest of the users are restricted (via GRANT commands) in the ways
they can access the tables.
Currently I cannot see how this can be done without having two
instances of the database (with all the overhead that implies.) Can
you suggest an alternative.
To respond with direct email please use ben_ryan_at_vancity.com
Ben Ryan - VanCity C.U.
Vancouver, B.C.