This discussion is archived
7 Replies Latest reply: Feb 13, 2013 1:17 PM by 990912 RSS

List of Oracle default users and roles

700063 Newbie
Currently Being Moderated
Hi,

I am using Oracle 10g and 11g.

Does anybody know where can I find a list of default (Out-of-the-box; user that are created during the Oracle installation) Oracle users and roles with the description of their purpose and use.

I have found a list on the web, but it seems it is not very current and only covers Oracle 8 and 9i.

http://www.idevelopment.info/data/Oracle/DBA_tips/Database_Administration/DBA_26.shtml

Thanks,

Regards,

Michal

Edited by: user10543032 on 15.2.2010 9:45
  • 1. Re: Oracle list of default users and roles
    729338 Expert
    Currently Being Moderated
    Hi,

    On 10g default users created are -

    ANONYMOUS
    CTXSYS
    DBSNMP
    DIP
    DMSYS
    EXFSYS
    MDDATA
    MDSYS
    MGMT_VIEW
    OLAPSYS
    ORACLE_OCM
    ORDPLUGINS
    ORDSYS
    OUTLN
    SCOTT
    SI_INFORMTN_SCHEMA
    SYS
    SYSMAN
    SYSTEM
    TSMSYS
    WMSYS
    XDB

    Roles
    -------
    CONNECT
    RESOURCE
    DBA
    SELECT_CATALOG_ROLE
    EXECUTE_CATALOG_ROLE
    DELETE_CATALOG_ROLE
    EXP_FULL_DATABASE
    IMP_FULL_DATABASE
    RECOVERY_CATALOG_OWNER
    GATHER_SYSTEM_STATISTICS
    LOGSTDBY_ADMINISTRATOR

    ROLE
    ------------------------------
    AQ_ADMINISTRATOR_ROLE
    AQ_USER_ROLE
    GLOBAL_AQ_USER_ROLE
    SCHEDULER_ADMIN
    HS_ADMIN_ROLE
    OEM_ADVISOR
    OEM_MONITOR
    WM_ADMIN_ROLE
    JAVAUSERPRIV
    JAVAIDPRIV
    JAVASYSPRIV

    ROLE
    ------------------------------
    JAVADEBUGPRIV
    EJBCLIENT
    JAVA_ADMIN
    JAVA_DEPLOY
    XDBADMIN
    CTXAPP
    AUTHENTICATEDUSER
    XDBWEBSERVICES
    OLAPI_TRACE_USER
    OLAP_DBA
    CWM_USER

    ROLE
    ------------------------------
    OLAP_USER
    MGMT_USER
  • 2. Re: Oracle list of default users and roles
    sb92075 Guru
    Currently Being Moderated
    select username from dba_users;
    select role from dba_roles;
  • 3. Re: Oracle list of default users and roles
    700063 Newbie
    Currently Being Moderated
    Thanks for quick responses, but where can I find a description and purpose of each user and role. Is there any documentation that covers this in a compact way?

    Queries should be correct. But I guess that if I do not have all the DB options installed and configured the queries will not show all the possible users and roles.
  • 4. Re: Oracle list of default users and roles
    729338 Expert
    Currently Being Moderated
    Hi,

    You may not find the purpose of each default users/roles in a document, but you can search about them individually. Most of the roles purpose are self explainatory.

    Regards
  • 5. Re: Oracle list of default users and roles
    sb92075 Guru
    Currently Being Moderated
    SQL> desc role_sys_privs
     Name                            Null?    Type
     ----------------------------------------- -------- ----------------------------
     ROLE                            NOT NULL VARCHAR2(30)
     PRIVILEGE                       NOT NULL VARCHAR2(40)
     ADMIN_OPTION                             VARCHAR2(3)
    query above to see which privileges are assigned to each ROLE
  • 6. Re: Oracle list of default users and roles
    729338 Expert
    Currently Being Moderated
    user10543032 wrote:
    Thanks for quick responses, but where can I find a description and purpose of each user and role. Is there any documentation that covers this in a compact way?

    Queries should be correct. But I guess that if I do not have all the DB options installed and configured the queries will not show all the possible users and roles.
    Hi,

    Queries should be correct. But I guess that if I do not have all the DB options installed and configured the queries will not show all the possible users and roles -> Query will not change. The above queries will give you all the users and roles in the database inrespective of the options installed on the database.

    HTH
  • 7. Re: List of Oracle default users and roles
    990912 Newbie
    Currently Being Moderated
    There are more roles to consider beyond what's been listed in this thread so far. Check out this list, in particular:

    http://docs.oracle.com/cd/E11882_01/network.112/e16543/authorization.htm#sthref598

    Edit: sorry, scroll up a bit on that link. I was searching for one particular role...
    Edited by: 987909 on Feb 13, 2013 1:16 PM

    Edited by: 987909 on Feb 13, 2013 1:17 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points