Database Administration (MOSC)

MOSC Banner

Database schema vs. user

edited Nov 1, 2013 8:48AM in Database Administration (MOSC) 17 commentsAnswered ✓
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:

CREATE USER USER_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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center