Database schema vs. user
Hello all,
I wonder if this scenario is possible. I want to separate the Oracle's user and the schema used in the database.
For instance, I created the following user and schema:
I'd like my application to connect to this database using USER_1.
And, after connect, all of other actions such as create/query/delete/update to tables, indexes or tablespaces will use SCHEMA_1.
For example:
I appreciate any help. Thank you.
- Trang
I wonder if this scenario is possible. I want to separate the Oracle's user and the schema used in the database.
For instance, I created the following user and schema:
CREATE USER USER_1 ...
CREATE SCHEMA AUTHORIZATION SCHEMA_1 ...
CREATE SCHEMA AUTHORIZATION SCHEMA_1 ...
I'd like my application to connect to this database using USER_1.
And, after connect, all of other actions such as create/query/delete/update to tables, indexes or tablespaces will use SCHEMA_1.
For example:
Select * from SCHEMA_1.mytable
I appreciate any help. Thank you.
- Trang
1