Oracle Learning NOTE 1: Tables and constraints

1. Log in to SQL Plus:

What are the system users:

1. Sys,system users with higher privileges;

2. Sysman Operations Enterprise Manager uses.

The 1.2 password is set by the installation of Oracle.

3. Scott user; The user's password is the default tiger.

(1), using System management user login Oracle;

　　

(2), connect the database:

(3). Re-login:

The user logged on successfully.

2. View the logged in User:

(1), check the login user "show user";

　　

(2), dba_users data dictionary:

(3), view user

3. Enable SCOOT User: Alter user username account unlock;

(1). Unlock Scott Users:

　　

(2), log in to Scott users:

After logging in, modify the user password "Tiger" to the Oracle "system" user password. Easy to remember.

The Scott user is enabled as of the above operation.

Oracle Learning NOTE 1: Tables and constraints