數據庫理論中數據庫用戶和數據庫模式並沒有必然的聯系,詳細的數據庫模式解釋可以在這裡找到:
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.
也就是說數據庫模式可以創建修改,並且可以給不同的用戶訪問也可以賦予不同的用戶。
而Oracle文檔《Concepts》中的解釋是這樣的:
A schemais 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.
雖然Oracle中模式也是數據對象的集合,但是在這裡一個用戶對應了一個模式,一個模式只能被一個數據庫用戶所擁有。