Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Difference between SYS and SYSTEM

Difference between SYS and SYSTEM

From: <vasarpota_at_my-deja.com>
Date: 2000/04/05
Message-ID: <8cfuca$bbo$1@nnrp1.deja.com>#1/1 






Can someone please tell me the difference between SYS and SYSTEM?  I
understand that both are users belonging to the DBA role.  I also
understand that they have different passwords.  But what is the real
difference besides the schema.  Is SYS used by DBAs and SYSTEM by
Oracle tools?  SYSTEM user can't view the data dictionary (owned by SYS
schema)?  Why have two?  Please Help



Thanks in advance for any help




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Wed Apr 05 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US