User accounts automatically created when Oracle Database is installed

Discussion

• Nirja Shah   -Posted on 28 Aug 15
  - Two user accounts are automatically created with the database:
  
  1. SYS (default password: CHANGE_ON_INSTALL) - When any database is created, the user SYS is automatically created and granted the DBA role.
  - All of the base tables and views for the database's data dictionary are stored in the schema SYS.
  - These base tables and views are critical for the operation of Oracle.
  - To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by Oracle.
  - They should never be modified by any user or database administrator, and no one should create any tables in the schema of user SYS.
  - Ensure that most database users are never able to connect using the SYS account.
  
  2. SYSTEM (default password: MANAGER) - When a database is created, the user SYSTEM is also automatically created and granted the DBA role.
  - The SYSTEM username is used to create additional tables and views that display administrative information, and internal tables and views used by various Oracle options and tools.
  - Never create in the SYSTEM schema tables of interest to individual users.

➨ Post your comment / Share knowledge