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: Default Sample Schema User Accounts lists the sample schema user accounts, which represent different divisions of a fictional company that manufactures various products.

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 User's 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.

Predefined Sample Schema User Accounts

Related Topics