Ways to start Scott users in Oracle 11GR2

Ways to start Scott users in Oracle 11GR2

The method for starting Scott users in Oracle, in Oracle11gr2, (g for ' network ') database in which Scott was locked in the user's installation ,

When you install Oracle, you can choose to unlock the user directly, and if you forget about the lock, you can use the sqlplus tool to unlock It later using the command.

　　

The default Scott user is locked out and will be able to log in using the database before unlocking.

Use the following statement to unlock Scott:alter user Scott account unlock;

You may be asked for this password after unlocking: Alter user Scott identified by Tiger;

Re-login: Sqlplus Scott/tiger

Then you can log in.

Note : To enable an account with the command line, you must set a password after unlocking it, or you will not be able to log in finally commit.

The completion gives the demonstration operation:

1. Open SQL Plus The result of the command execution is:

2, login system, (password, is installed when the password set, such as 1234), the interface is as follows

3. Log in to Oracle database with SYS user,

Input command: conn as SYSDBA;

After the command execution prompt: Enter the user name, then prompt for the password, the system check correctly, you can connect.

Use show user; command to view the currently logged on user.

Sql> Show user; USER is "SYS"

4. Use SYS to enable Scott users:

Enter the command:

sql> alter user Scott account unlock; users have changed.

Sql> alter user Scott identified by Tiger;

Sql> conn Scott; Enter the password: * * * is connected.

Sql> Show user;

USER is "SCOTT"

5. Use the Oracle command to view all users that already exist in the current database

Data dictionary dba_users View the status of the Scott account now, the command is as follows:

Sql> Select Username, account_stastus from dbs_users where username = ' SCOTT ';

Ways to start Scott users in Oracle 11GR2