Oracle Users
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle Users

  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Question Oracle Users

    Hi all,

    Can I know the default Oracle users? Is there any script searchs for them? The other question, what are the differences between sys/system users??? waiting your replay..Thanks in advance!!

  2. #2
    Join Date
    Feb 2002
    Posts
    70
    You can find the info by querying DBA_USERS table. It gives all the user names currently created in the database.

    Default users that are created by Oracle will vary.
    SYS
    SYSTEM
    SCOTT
    BLAKE
    ADAMS
    OUTLN
    DBSNMP
    CLARK
    JONES
    OMWB_EMULATION
    ________________
    ShanDJ

  3. #3
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Depending on the options you have installed, default users varies, but you might find these users:
    SYS, SYSTEM, OUTLN, DBSNMP, MTSSYS, AURORA$ORB$UNAUTHENTICATED, SCOTT
    DEMO, ORDSYS, ORDPLUGINS, MDSYS, CTXSYS

    SYS is the Oracle dictionary owner, whereas SYSTEM is a user who has been granted all DBA roles and has access to entire dictionary. In other words you can say SYS is the owner of the company and SYSTEM is the manager who has access to all company's funds (and who can screw the company's financial status if he wants)
    Agasimani
    OCP(10g/9i/8i/8)

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