default user accounts in 11G oracle database – for the new oracle dba




you are a new oracle dba and you want to find out all the default user accounts that could be possible when you installed a new 11G oracle database.below is the information about what those useraccounts mean.

 

Table 3-1 Predefined Oracle Database Administrative User Accounts

User Account

Description

Status After Installation

ANONYMOUS Account that allows HTTP access to Oracle XML DB. It is used in place of the APEX_PUBLIC_USER account when the Embedded PL/SQL Gateway (EPG) is installed in the database.

EPG is a Web server that can be used with Oracle Database. It provides the necessary infrastructure to create dynamic applications.

Expired and locked
CTXSYS The account used to administer Oracle Text. Oracle Text enables you to build text query applications and document classification applications. It provides indexing, word and theme searching, and viewing capabilities for text.

See Oracle Text Application Developer’s Guide.

Expired and locked
DBSNMP The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database.

See Oracle Enterprise Manager Grid Control Installation and Basic Configuration.

Open

Password is created at installation or database creation time.

EXFSYS The account used internally to access the EXFSYS schema, which is associated with the Rules Manager and Expression Filter feature. This feature enables you to build complex PL/SQL rules and expressions. The EXFSYS schema contains the Rules Manager and Expression Filter DDL, DML, and associated metadata.

See Oracle Database Rules Manager and Expression Filter Developer’s Guide.

Expired and locked
LBACSYS The account used to administer Oracle Label Security (OLS). It is created only when you install the Label Security custom option.

See “Enforcing Row-Level Security with Oracle Label Security” and Oracle Label Security Administrator’s Guide.

Expired and locked
MDSYS The Oracle Spatial and Oracle Multimedia Locator administrator account.

See Oracle Spatial Developer’s Guide.

Expired and locked
MGMT_VIEW An account used by Oracle Enterprise Manager Database Control. Open

Password is randomly generated at installation or database creation time. Users do not need to know this password.

OLAPSYS The account that owns the OLAP Catalog (CWMLite). This account has been deprecated, but is retained for backward compatibility. Expired and locked
ORDDATA ../../appdev.112/e10778/ch_adm_over.htm – IMDCM7150This account contains the Oracle Multimedia DICOM data model. See Oracle Multimedia DICOM Developer’s Guide for more information. Expired and locked
OWBSYS The account for administrating the Oracle Warehouse Builder repository.

Access this account during the installation process to define the base language of the repository and to define Warehouse Builder workspaces and users. A data warehouse is a relational or multidimensional database that is designed for query and analysis.

See Oracle Warehouse Builder Installation and Administration Guide.

Expired and locked
ORDPLUGINS The Oracle Multimedia user. Plug-ins supplied by Oracle and third-party, format plug-ins are installed in this schema.

Oracle Multimedia enables Oracle Database to store, manage, and retrieve images, audio, video, DICOM format medical images and other objects, or other heterogeneous media data integrated with other enterprise information.

See Oracle Multimedia User’s Guide and Oracle Multimedia Reference.

Expired and locked
ORDSYS The Oracle Multimedia administrator account.

See Oracle Multimedia User’s Guide, Oracle Multimedia Reference, and Oracle Multimedia DICOM Developer’s Guide.

Expired and locked
OUTLN The account that supports plan stability. Plan stability prevents certain database environment changes from affecting the performance characteristics of applications by preserving execution plans in stored outlines. OUTLN acts as a role to centrally manage metadata associated with stored outlines.

See Oracle Database Performance Tuning Guide.

Expired and locked
SI_INFORMTN_SCHEMA The account that stores the information views for the SQL/MM Still Image Standard.

See Oracle Multimedia User’s Guide and Oracle Multimedia Reference.

Expired and locked
SYS An account used to perform database administration tasks.

See Oracle Database 2 Day DBA.

Open

Password is created at installation or database creation time.

SYSMAN The account used to perform Oracle Enterprise Manager database administration tasks. The SYS and SYSTEM accounts can also perform these tasks.

See Oracle Enterprise Manager Grid Control Installation and Basic Configuration.

Open

Password is created at installation or database creation time.

SYSTEM A default generic database administrator account for Oracle databases.

For production systems, Oracle recommends creating individual database administrator accounts and not using the generic SYSTEM account for database administration operations.

See Oracle Database 2 Day DBA.

Open

Password is created at installation or database creation time.

WK_TEST The instance administrator for the default instance, WK_INST. After you unlock this account and assign this user a password, then you must also update the cached schema password using the administration tool Edit Instance Page.

Ultra Search provides uniform search-and-location capabilities over multiple repositories, such as Oracle databases, other ODBC compliant databases, IMAP mail servers, HTML documents managed by a Web server, files on disk, and more.

See Oracle Ultra Search Administrator’s Guide.

Expired and locked
WKSYS An Ultra Search database super-user. WKSYS can grant super-user privileges to other users, such as WK_TEST. All Oracle Ultra Search database objects are installed in the WKSYS schema.

See Oracle Ultra Search Administrator’s Guide.

Expired and locked
WKPROXY An administrative account of Oracle9i Application Server Ultra Search.

See Oracle Ultra Search Administrator’s Guide.

Expired and locked
WMSYS The account used to store the metadata information for Oracle Workspace Manager.

See Oracle Database Workspace Manager Developer’s Guide.

Expired and locked
XDB The account used for storing Oracle XML DB data and metadata.

Oracle XML DB provides high-performance XML storage and retrieval for Oracle Database data.

See Oracle XML DB Developer’s Guide.

Expired and locked

Note:

If you create an Oracle Automatic Storage Management (Oracle ASM) instance, then the ASMSNMP account is created. Oracle Enterprise Manager uses this account to monitor ASM instances to retrieve data from ASM-related data dictionary views. The ASMSNMP account status is set to OPEN upon creation, and it is granted the SYSDBA privilege. For more information, see Oracle Automatic Storage Management Administrator’s Guide.

Predefined Non-Administrative User Accounts

Table 3-2 lists default non-administrative user accounts that are created when you install Oracle Database. Non-administrative user accounts only have the minimum privileges needed to perform their jobs. Their default tablespace is USERS.

To protect these accounts from unauthorized access, the installation process locks and expires these accounts immediately after installation, except where noted in Table 3-2. As the database administrator, you are responsible for unlocking and resetting these accounts, as described in “Expiring and Locking Database Accounts”.

Table 3-2 Predefined Oracle Database Non-Administrative User Accounts

User Account

Description

Status After Installation

APEX_PUBLIC_USER The Oracle Database Application Express account. Use this account to specify the Oracle schema used to connect to the database through the database access descriptor (DAD).

Oracle Application Express is a rapid, Web application development tool for Oracle Database.

See Oracle Application Express Application Builder User’s Guide.

Expired and locked
DIP The Oracle Directory Integration and Provisioning (DIP) account that is installed with Oracle Label Security. This profile is created automatically as part of the installation process for Oracle Internet Directory-enabled Oracle Label Security.

See Oracle Label Security Administrator’s Guide.

Expired and locked
FLOWS_30000 The account that owns most of the database objects created during the installation of Oracle Database Application Express. These objects include tables, views, triggers, indexes, packages, and so on.

See Oracle Application Express Application Builder User’s Guide.

Expired and locked
FLOWS_FILES The account that owns the database objects created during the installation of Oracle Database Application Express related to modplsql document conveyance, for example, file uploads and downloads. These objects include tables, views, triggers, indexes, packages, and so on.

See Oracle Application Express Application Builder User’s Guide.

Expired and locked
MDDATA The schema used by Oracle Spatial for storing Geocoder and router data.

Oracle Spatial provides a SQL schema and functions that enable you to store, retrieve, update, and query collections of spatial features in an Oracle database.

See Oracle Spatial Developer’s Guide.

Expired and locked
ORACLE_OCM The account used with Oracle Configuration Manager. This feature enables you to associate the configuration information for the current Oracle Database instance with My Oracle Support. Then when you log a service request, it is associated with the database instance configuration information.

See Oracle Database Installation Guide for your platform.

Expired and locked
SPATIAL_CSW_ADMIN_USR The Catalog Services for the Web (CSW) account. It is used by Oracle Spatial CSW Cache Manager to load all record-type metadata and record instances from the database into the main memory for the record types that are cached.

See Oracle Spatial Developer’s Guide.

Expired and locked
SPATIAL_WFS_ADMIN_USR The Web Feature Service (WFS) account. It is used by Oracle Spatial WFS Cache Manager to load all feature type metadata and feature instances from the database into main memory for the feature types that are cached.

See Oracle Spatial Developer’s Guide.

Expired and locked
XS$NULL An internal account that represents the absence of a user in a session. Because XS$NULL is not a user, this account can only be accessed by the Oracle Database instance. XS$NULL has no privileges and no one can authenticate as XS$NULL, nor can authentication credentials ever be assigned to XS$NULL. Expired and locked

 

Predefined Sample Schema User Accounts

If you install the sample schemas, which you must do to complete the examples in this guide, Oracle Database creates a set of sample user accounts. The sample schema user accounts are all non-administrative accounts, and their tablespace is USERS.

To protect these accounts from unauthorized access, the installation process locks and expires these accounts immediately after installation. As the database administrator, you are responsible for unlocking and resetting these accounts, as described in “Expiring and Locking Database Accounts”. For more information about the sample schema accounts, see Oracle Database Sample Schemas.

Table 3-3 lists the sample schema user accounts, which represent different divisions of a fictional company that manufactures various products.

Table 3-3 Default Sample Schema User Accounts

User Account

Description

Status After Installation

BI The account that owns the BI (Business Intelligence) schema included in the Oracle Sample Schemas.

See also Oracle Warehouse Builder Sources and Targets Guide.

Expired and locked
HR The account used to manage the HR (Human Resources) schema. This schema stores information about the employees and the facilities of the company. Expired and locked
OE The account used to manage the OE (Order Entry) schema. This schema stores product inventories and sales of the company’s products through various channels. Expired and locked
PM The account used to manage the PM (Product Media) schema. This schema contains descriptions and detailed information about each product sold by the company. Expired and locked
IX The account used to manage the IX (Information Exchange) schema. This schema manages shipping through business-to-business (B2B) applications. Expired and locked
SH The account used to manage the SH (Sales) schema. This schema stores business statistics to facilitate business decisions. Expired and locked

In addition to the sample schema accounts, Oracle Database provides another sample schema account, SCOTT. The SCOTT schema contains the tables EMP, DEPT, SALGRADE, and BONUS. The SCOTT account is used in examples throughout the Oracle Database documentation set. When you install Oracle Database, the SCOTT account is locked and expired.

 

Author: admin