Difference between SYS and SYSTEM in Oracle 10g?

220 pts.
Tags:
Oracle 10g
Oracle 10g administration
Oracle 10g Express
Oracle User Profiles
wat is the difference between SYS and SYSTEM users in ORACLE?

Software/Hardware used:
Oracle 10 g express edition
ASKED: November 23, 2010  7:39 AM
UPDATED: November 23, 2010  2:25 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Of course there r some differences ….
<b>SYS:</b> 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 the user SYS. The default pass is change_on_install
<b>SYSTEM:</b> The SYSTEM user name creates additional tables and views that display administrative information, and internal tables and views used by Oracle tools. Never create in the SYSTEM schema tables of interest to individual users. SYSTEM is a little bit “weaker” user than SYS, for example, it has no access to so called a$ tables. Although in real life u may be in a situation when some product or whatever u want to create objects in above mentioned user’s schemas. The default pass is : manager.
In one sentence it may be defined as
SYS is the data dictionary owner and SYSTEM is intended for database administration.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Prcvjr
    Thank u very much. it is very nice answer. now i got to know the difference,.
    220 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following