Concepts of User and Schema in Oracle, oracleschema

Concepts of User and Schema in Oracle, oracleschema

In database theory, database users and database models are not necessarily related. For detailed explanations of database models, you can find them here:

Http://stackoverflow.com/questions/2674222/what-is-purpose-of-database-schema

A database schema is a way to logically group objects such as tables, views, stored procedures etc. think of a schema as a container of objects. you can assign a user login permissions to a single schema so that the user can only access the objects they are authorized to access.

Schemas can be created and altered in a database, and users can be granted access to a schema. A schema can be owned by any user, and schema ownership istransferable.

That is to say, the database mode can be created and modified, and different users can be accessed by different users.

In the Oracle document Concepts, the explanation is as follows:

ASchemaIs a collection of logical structures of data, or schema objects. A schema is

Owned by a database user and has the same name as that user. Each user owns a single
Schema.

Although the schema in Oracle is also a collection of data objects, a user corresponds to one schema, and a schema can only be owned by one database user.