Different SYS and SYSTEM User on Oracle


SYS
  • automatically created when Oracle database is installed
  • automatically granted the DBA role
  • has a default password: CHANGE_ON_INSTALL (make sure you change it)
  • owns the base tables and views for the database data dictionary
  • the default schema when you connect as SYSDBA
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. Database users should not connect to the Oracle database using the SYS account.
SYSTEM
  • automatically created when Oracle database is installed
  • automatically granted the DBA role
  • has a default password: MANAGER (make sure you change it)
  • used to create additional tables and views that display administrative information
  • used to create internal tables and views used by various Oracle database options and tools
Never use the SYSTEM schema to store tables of interest to non-administrative users.

3 thoughts on “Different SYS and SYSTEM User on Oracle

  1. Hi,
    appreciate if you could help me how to override the sys password.

    ive have tried to override by running the command orapwd, it seem im cant write the file by the name PWDorcl.ora to the directory.

    urgent, i cant work without sys dba password.

    ps. the oracle has being install in by different person, i didnt have the password and the person cant be contacted. appreciate your help for any other workaround. Thank you.

    1. You can login via console
      $ sqlplus /nolog
      SQL> conn /as sysdba
      SQL> alter user sys identified by

      I hope can help u

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s