7 Replies Latest reply: Feb 19, 2013 11:26 AM by 960887 RSS

    Difference between SYS and SYSTEM

    Blues Breaker
      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
          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 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
              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
                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
                  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
                    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
                      Thank You.............