OraFAQ Forum: Server Administration » What's the difference between sys and system ?

Home » RDBMS Server » Server Administration » What's the difference between sys and system ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What's the difference between sys and system ? [message #63169]

Wed, 15 September 2004 10:56

jack
Messages: 123
Registered: September 2000

Senior Member

What is the difference between user sys and system when I am administrating database?

Thanks in advance

Jack

Report message to a moderator

Re: What's the difference between sys and system ? [message #63170 is a reply to message #63169]

Wed, 15 September 2004 11:39

Susan
Messages: 102
Registered: October 2001

Senior Member

See:

http://asktom.oracle.com/pls/ask/f?p=4950:8:4968742777126581190::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1265600484161,

Report message to a moderator

Re: What's the difference between sys and system ? [message #63171 is a reply to message #63170]

Wed, 15 September 2004 18:16

jack
Messages: 123
Registered: September 2000

Senior Member

Thanks susan, while I found that article you refered to just gave me some using advices. I hope you can give the difference about the two.

Thanks

Jack

Report message to a moderator

Re: What's the difference between sys and system ? [message #63180 is a reply to message #63171]

Thu, 16 September 2004 03:46

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

SYS is the owner of the oracle dictionary.
THE DEFAULT superuser or like a 'root' in a oracle database.
Oracle strongly recomends NOT TO use SYS for any regular adminstration tasks.

please have a look here

http://www.orafaq.com/usenet/comp.databases.oracle.server/2003/08/06/0511.htm

system is just another account with administrative privs ( by default cannot start/shut databases)

quoting docs
"The Oracle user SYS owns all base tables and user-accessible views of the data dictionary. Therefore, no Oracle user should ever alter (update, delete, or insert) any rows or schema objects contained in the SYS schema, because such activity can compromise data integrity. The security administrator should keep strict control of this central account."

"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."

Report message to a moderator

Re: What's the difference between sys and system ? [message #163086 is a reply to message #63180]

Tue, 14 March 2006 21:31

selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai

Senior Member

thanx a lot

Report message to a moderator

Previous Topic:	How to generate the sql scripts??
Next Topic:	Installtion problem of oracle 8i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 18 19:17:38 CST 2025