When you create an Oracle Database, the user SYS is automatically created and
granted the DBA role.
All of the base tables and views for the database data dictionary are stored in the
schema SYS. 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, and no one should create any tables in the schema of user SYS.
(However, you can change the storage parameters of the data dictionary settings if
necessary.)
Ensure that most database users are never able to connect to Oracle Database using the
SYS account.
sys用户
基表 , 视图 , 数据库字典都属于sys方案
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-994273/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002853
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
