OraFAQ Forum: Server Administration » Why we find 2 ADMINS ( SYS and SYSTEM )!!?

Home » RDBMS Server » Server Administration » Why we find 2 ADMINS ( SYS and SYSTEM )!!?

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

Why we find 2 ADMINS ( SYS and SYSTEM )!!? [message #219752]

Thu, 15 February 2007 17:27

iverson
Messages: 1
Registered: February 2007
Location: tunisia

Junior Member

hi everybody!!
I wanna just know why we find 2 administrators account in ORACLE ...i know that there is some differences between SYS and SYSTEM accounts but.. Why 2 accounts??
why it's not only one who regroups all fonctionalities and options??
thnak you very much!! Wink

Report message to a moderator

Re: Why we find 2 ADMINS ( SYS and SYSTEM )!!? [message #219757 is a reply to message #219752]

Thu, 15 February 2007 19:16

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

Senior Member
Account Moderator

Always search before posting.
http://www.orafaq.com/forum/t/22610/0/
sys/system are the default admins.
Never use these for regular database administration.
Like in unix, you never use ROOT for regular system admin.
>>why it's not only one who regroups all fonctionalities and options??
Would be quite a pain.
SYS here is the absolute superuser and owner of Oracle dictionary.
SYSTEM would be just another DBA user with a few more additional privs.

Report message to a moderator

Re: Why we find 2 ADMINS ( SYS and SYSTEM )!!? [message #219758 is a reply to message #219752]

Thu, 15 February 2007 19:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Based upon your logic then you only need SYS schema & let everyone run as SYS.
You are free to do so on your instances if you want to keep things very simple.
SYS & SYSTEM are different schemas & own different objects.

SQL> select count(*) from dba_objects where owner = 'SYS';

COUNT(*)
----------
23242

SQL> select count(*) from dba_objects where owner = 'SYSTEM';

COUNT(*)
----------
460

Report message to a moderator

Previous Topic:	one query plz
Next Topic:	Oracle Streams questions (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:26:24 CDT 2024