The history of scott/tiger

scott/tiger

Almost every Oracle database has had an account called SCOTT with password TIGER. It is named after Bruce Scott (one of the original Oracle employees) and the password is the name of his daughter’s cat. This schema contains the EMP and DEPT tables used in innumerable demos. In recent versions of the database, this account is locked by default and must be unlocked with

SQL> ALTER USER SCOTT ACCOUNT UNLOCK;

Oracle XE inexplicably doesn’t have this classic account, but you can add the user yourself and fill it using the demobld script.

Later versions has an additional demo schema called HR with password HR. This schema contains many additional database objects to allow demonstration of newer database features.

The following links discuss the new sample schemas in more detail.

To drop Scott you need to run the demodrop.sql script

Source: http://wiki.oracle.com/page/scott%2Ftiger

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s