SYS vs. SYSTEM
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SYS vs. SYSTEM

  1. #1
    Join Date
    Jul 2002
    Location
    Taiwan
    Posts
    9
    hello,

    What is the major difference between Account SYS and SYSTEM in Oracle9i database ??
    when should I use SYS and when should I use SYSTEM ??

    thanks a lot for your reply ......


  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    SYS owns almost everything of any importance in the database, apart from your data. As such, getting something wrong here can seriously mess up your database.

    SYSTEM may own a few objects depending on the options loaded, but essentially is an administrative user. Alot of the things you can do as SYS can also be done as SYSTEM, but it does have slighly less privileges as it's not the object owner.

    DBA users should be set up to do all your common DBA tasks.

    A basic rule of thumb is:

    Try as a DBA.
    If that doesn't work try as SYSTEM.
    If that doesn't work try as SYS.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  3. #3
    Join Date
    Aug 2002
    Posts
    2

    Talking

    only and main defernce is sys is the owner of data dictionery views where as system is not.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width