Author: James Caperfield
Page:
1
2
Oracle creates a number of default database users or schemas when a new database is created. In this article I will discuss some of these users or schemas that every database administrator must know.
SYS/CHANGE_ON_INSTALL or INTERNAL:
- The password for SYS/CHANGE_ON_INSTALL or INTERNAL can be changed. The password must be changed right after the database is created.
- SYS/CHANGE_ON_INSTALL or INTERNAL can not be dropped.
- SYS/CHANGE_ON_INSTALL or INTERNAL is created by
?/rdbms/admin/sql.bsq and various cat*.sql scripts
SYSTEM/MANAGER:
- SYSTEM/MANAGER is the default database administrator user name. Please do not use SYS
- The password for SYSTEM/MANAGER can be changed but it should be changed right after the database is created.
- SYSTEM/MANAGER user can not be dropped.
- SYSTEM/MANAGER is created by
?/rdbms/admin/sql.bsq
OUTLN/OUTLN:
- OUTLN/OUTLN is stored outlines for optimizer plan stability.
- The password for OUTLN/OUTLN can be changed but it should be changed right after the database is created.
- OUTLN/OUTLN user can not be dropped.
- OUTLN/OUTLN is created by
?/rdbms/admin/sql.bsq
SCOTT/TIGER, ADAMS/WOOD, JONES/STEEL, CLARK/CLOTH and BLAKE/PAPER:
- These are Training/ demonstration users containing the popular EMP and DEPT tables.
- The password for these users can be changed.
- You can drop users cascade from all production environments.
- You can create these users by running the below script
?/rdbms/admin/utlsampl.sql
HR/HR (Human Resources), OE/OE (Order Entry), SH/SH (Sales History):
- These are training/ demonstration users containing the popular EMPLOYEES and DEPARTMENTS tables.
- The password for these users can be changed.
- You can drop these users. Drop users cascade from all production environments.
- You can create these users running the below script.
?/demo/schema/mksample.sql
CTXSYS/CTXSYS:
- CTXSYS/CTXSYS is the Oracle interMedia (ConText Cartridge) administrator user.
- You can create CTXSYS/CTXSYS user by running the below script.
?/ctx/admin/dr0csys.sql
Page:
1
2
More Oracle Articles, Database Articles and DBA Tips
Database Security: Step by step guideline
Great Tips on Reusing Space after deletion of database data!!
Beware of killing the wrong Oracle Session!!
Expert Tips on Drop Temporary Tablespace Hangs!!
Step by Step Guide to Oracle Parsing
|
