This account can perform all administrative functions. All base (underlying) tables and views for the database data dictionary are stored in the SYS schema. These base tables and views are critical for the operation of Oracle Database. To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by the database. They should never be modified by any user or database administrator. You must not create any tables in the SYS schema.The SYS user is granted the SYSDBA privilege, which enables a user to perform high-level administrative tasks such as backup and recovery.
SYS
这个账户可以完成所有的管理功能,所有的数据库基本表和视图都存储在SYS架构中。这些基本的表和视图对于Oracle数据库的操作很关键。为了维持数据词典的一致性,在SYS架构中的表只能由数据库来操纵。它们不能被任何的用户和数据库管理员修改。你不能在SYS架构中创建任何的表。SYS用户拥有SYSDBA权限,它可以执行比如备份和恢复这样的高级别的管理任务。
■ SYSTEMThis account can perform all administrative functions except the following:
– Backup and recovery
– Database upgrade
While this account can be used to perform day-to-day administrative tasks, Oracle strongly recommends creating named users account for administering the Oracle database to enable monitoring of database activity.
SYSTEM
这个账号可以执行所有的管理功能,除过以下内容:
一备份和恢复
一数据库升级
由于这个账户可以用来执行每天的管理任务,Oracle强烈推荐创建命名账户来管理Oracle数据库,以启用数据库动态监控。