October 17, 2012

Oracle database default setup Users and their Passwords

When you install Oracle database engine using default installation configuration, few superusers are created.

Two such users are:
  • SYS
  • SYSTEM
Users SYS and SYSTEM are:
– created automatically during database creation,
– granted the DBA role.

• User SYS
– Owner of the database data dictionary
– Default password: change_on_install

• User SYSTEM
– Owner of additional internal tables and views used by Oracle tools
– Default password: manager

Hope you won't again be depressed if you forget to check or change default passwords of these users while setting Oracle database engine up!

Did you know:
You can easily find i-tech-freak.blogspot.com listed on first page of Google search results by querying for "i-tech-freak". Enjoy reading.

No comments:

Post a Comment

Add your say here: