7 Replies Latest reply: Feb 13, 2013 3:17 PM by 990912 RSS

    List of Oracle default users and roles

    700063
      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
          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
            select username from dba_users;
            select role from dba_roles;
            • 3. Re: Oracle list of default users and roles
              700063
              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
                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
                  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
                    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
                      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