本文介绍了数据库中的架构概念，包括模式、用户及目录等核心组件。详细解释了模式对象如何组织数据库的数据，以及用户和用户组如何帮助管理员进行安全性管理。此外，还讨论了数据库实例目录中包含的元数据类型。
A schema is a collection of database objects (used by a user.).
Schema objects are the logical structures that directly refer to the database’s data.
A user is a name defined in the database that can connect to and access objects.
Schemas and users help database administrators manage database security.
The database catalog of a database instance consists of metadata in which definitions of database objects such as Basis tables, view tables, synonyms, value ranges, indexes, users, and user groups are stored.
The database catalog is made up of the following sections:
· Information about the installation of the database system and metadata with the definitions of users and user groups
This part is not assigned to any user or any user group.
· Metadata for the objects that have been created by a user or a user group
This includes metadata about basis tables and view tables.
Schema objects are the logical structures that directly refer to the database’s data.
A user is a name defined in the database that can connect to and access objects.
Schemas and users help database administrators manage database security.
The database catalog of a database instance consists of metadata in which definitions of database objects such as Basis tables, view tables, synonyms, value ranges, indexes, users, and user groups are stored.
The database catalog is made up of the following sections:
· Information about the installation of the database system and metadata with the definitions of users and user groups
This part is not assigned to any user or any user group.
· Metadata for the objects that have been created by a user or a user group
This includes metadata about basis tables and view tables.
扫一扫
3766
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
