Multiple schemas with accessing one table?
Hi there
I'm looking for some advice on a specific style of structuring the database.
We have a custom application that is java based. Users and connections are managed by the application. Our environment is one database with about 50 schemas with 50 instances of the application hitting the database. The data that is contained in the database is very sensitive data and originally, we structured the DB so that each client was self contained in one schema.
Now, our developers are looking to correct their code for it to be nicer to oracle. They want to have the same structure as above, but to have one table (we'll call it the patient table) to be accessible to all schemas, but only have rights to the data that the schema needs. Is there a way of setting this up?
I'm looking for some advice on a specific style of structuring the database.
We have a custom application that is java based. Users and connections are managed by the application. Our environment is one database with about 50 schemas with 50 instances of the application hitting the database. The data that is contained in the database is very sensitive data and originally, we structured the DB so that each client was self contained in one schema.
Now, our developers are looking to correct their code for it to be nicer to oracle. They want to have the same structure as above, but to have one table (we'll call it the patient table) to be accessible to all schemas, but only have rights to the data that the schema needs. Is there a way of setting this up?
0