Oracle中用户和模式之间的区别?

2021-12-05 00:00:00 oracle

Oracle 中的用户和模式有什么区别?

What is the difference between a user and a schema in Oracle?

推荐答案

来自 问汤姆

您应该将架构视为用户帐户和其中所有对象的集合作为所有意图和目的的模式.

You should consider a schema to be the user account and collection of all objects therein as a schema for all intents and purposes.

SCOTT 是一种架构,其中包括具有各种授权的 EMP、DEPT 和 BONUS 表,以及其他东西.

SCOTT is a schema that includes the EMP, DEPT and BONUS tables with various grants, and other stuff.

SYS 是一个包含大量表、视图、授权等的架构.

SYS is a schema that includes tons of tables, views, grants, etc etc etc.

SYSTEM 是一个架构.....

SYSTEM is a schema.....

从技术上讲——模式是数据库使用的一组元数据(数据字典),通常使用 DDL 生成.模式定义了数据库的属性,例如表、列和属性.数据库模式是对数据的描述数据库.

Technically -- A schema is the set of metadata (data dictionary) used by the database, typically generated using DDL. A schema defines attributes of the database, such as tables, columns, and properties. A database schema is a description of the data in a database.

相关文章