Google
Information Storage and Retrieval: What is the difference between an Oracle User and an Oracle Schema?

Pages

Sunday, January 19, 2014

What is the difference between an Oracle User and an Oracle Schema?

An Oracle schema is a collection of database objects like tables, functions, indexes etc A user "owns" a schema. When a user is created, it is given access to a schema with same name. A user can be given access to objects of other schema.

For all intents and purposes you can consider a user to be a schema and a schema to be a user.

No comments: