Home » RDBMS Server » Server Administration » Why we find 2 ADMINS ( SYS and SYSTEM )!!?
icon12.gif  Why we find 2 ADMINS ( SYS and SYSTEM )!!? [message #219752] Thu, 15 February 2007 17:27 Go to next message
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
Re: Why we find 2 ADMINS ( SYS and SYSTEM )!!? [message #219757 is a reply to message #219752] Thu, 15 February 2007 19:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.

Re: Why we find 2 ADMINS ( SYS and SYSTEM )!!? [message #219758 is a reply to message #219752] Thu, 15 February 2007 19:19 Go to previous message
BlackSwan
Messages: 25045
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
Previous Topic: one query plz
Next Topic: Oracle Streams questions (merged)
Goto Forum:
  


Current Time: Wed Dec 07 18:50:21 CST 2016

Total time taken to generate the page: 0.19555 seconds