Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference Between Schema & USer

720666Jul 28 2011 — edited Jul 28 2011

Please let me know the exact difference between Schema & user ?

Can we have various users assigned to a particular Schema .

My issue is that I am not able to decide in which case we need to design a more than 1 schema OR just assign different users to a schema ?
My database is accessed by 2 type of application
1. Java (Stores Data)
2. Domino (Stores metadata)
Each application have specific set of tables , but as a DBA - data of both the applications is interlinked & joins will b applied to generate future report .

kindly suggest should I make same Schema with 2 users OR 2 different schema .
Please suggest ??

I have already seen this link by TOM :
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:974699100346868838

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 25 2011

Added on Jul 28 2011

#general-database-discussions, #schema, #user

2 comments

198 views