Oracle 12c Difference between Schema and user

Hi Team,

I have started to work on Oracle 12c , Iam not able to identify the difference between Schema and User in oracle 12c , any  help in this regard is really appreciated.
sam_2012Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sdstuberCommented:
in oracle they are the same thing.

but ----  usually the word "schema" refers to a user that owns objects.

whereas "user" could be either a schema, or simply somebody logging in.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Of course there is a distinction, but it is more of a formal nature.
A schema contains objects.
A user has privileges. The user determines passwords, which schemas can be accessed, and more.

In Oracle schema and user often have the same name. A user is automatically owner of the schema named the same.
1
slightwv (䄆 Netminder) Commented:
>>between Schema and User in oracle 12c

Wanted to point out that 12c makes no difference.  It has been that way in Oracle since the beginning or at least as far back as I go with Oracle and that is Version 6.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.