This discussion is archived
7 Replies Latest reply: Feb 19, 2013 9:26 AM by 960887 RSS

Difference between SYS and SYSTEM

Blues Breaker Newbie
Currently Being Moderated
Could somebody explain the difference between these accounts? Another admin told me they always use SYSTEM and I always use SYS. There are many more objects owned by SYS (such as the DD) and I never gave it much thought. I noticed in MetaLink they suggested in a few places never to use SYSTEM and to use SYS instead for certain tasks. I suspect they have their own function and the installer seems to indicate that those accounts are created at the same time.
Thanks for any insight.
  • 1. Re: Difference between SYS and SYSTEM
    439075 Newbie
    Currently Being Moderated
    Hi,

    From Jeff Hunter we see an excellent summary of the SYS and SYSTEM schemas:

    - Oracle Created (Default) Database Users
    http://www.idevelopment.info/data/Oracle/DBA_tips/Database_Administration/DBA_26.shtml


    Hope it helps.

    Cheers,
    Marcello M.
  • 2. Re: Difference between SYS and SYSTEM
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    Oracle online doc exists for such question :
    http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/dba.htm#sthref118

    Nicolas.
  • 3. Re: Difference between SYS and SYSTEM
    960887 Newbie
    Currently Being Moderated
    Hi to all,

    I got the difference between the two users of sys and system from above part.
    Thanks for your Information

    But can any one clarify when and in which situations we connect to system user to perform?

    and

    Why we need to run pupbld.sql script as system? Is there any reason behind it?


    Thanks & Regards

    Akhil

    Edited by: 957884 on Feb 18, 2013 11:16 AM
  • 4. Re: Difference between SYS and SYSTEM
    sb92075 Guru
    Currently Being Moderated
    957884 wrote:
    Hi to all,

    I got the difference between the two users of sys and system from above part.
    Thanks for your Information

    But can any one clarify when and in which situations we connect to system user to perform?
    Only when directed by Oracle to do so; otherwise NEVER
  • 5. Re: Difference between SYS and SYSTEM
    960887 Newbie
    Currently Being Moderated
    Thanks for reply....

    I hope the answer for below question also...

    "Why we need to run pupbld.sql script as system? Is there any reason behind it?"


    Thanks & Regards

    Akhil
  • 6. Re: Difference between SYS and SYSTEM
    sb92075 Guru
    Currently Being Moderated
    957884 wrote:
    Thanks for reply....

    I hope the answer for below question also...

    "Why we need to run pupbld.sql script as system? Is there any reason behind it?"


    Thanks & Regards

    Akhil
    [oracle@localhost ~]$ more /home/oracle/app/oracle/product/11.2.0/dbhome_2/sqlplus/admin/pupbld.sql
    --
    -- Copyright (c) Oracle Corporation 1988, 2003.  All Rights Reserved.
    --
    -- NAME
    --   pupbld.sql
    --
    -- DESCRIPTION
    --   Script to install the SQL*Plus PRODUCT_USER_PROFILE tables.  These
    --   tables allow SQL*Plus to disable commands per user.  The tables
    --   are used only by SQL*Plus and do not affect other client tools
    --   that access the database.  Refer to the SQL*Plus manual for table
    --   usage information.
    --
    --   This script should be run on every database that SQL*Plus connects
    --   to, even if the tables are not used to restrict commands.
    
    -- USAGE
    --   sqlplus system/<system_password> @pupbld
    --
    --   Connect as SYSTEM before running this script
    Because Oracle Says to do so; see above!
  • 7. Re: Difference between SYS and SYSTEM
    960887 Newbie
    Currently Being Moderated
    Thank You.............