Ways to start Scott users in Oracle 11GR2

The method of launching Scott users in Oracle, in Oracle11gr2, (g for ' network ') in the database Scott this user is locked during installation, when you install Oracle, you can directly choose to unlock the user, if you forget to understand the lock, later can To use the Sqlplus tool to unlock it by 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:[sql] View plaincopy alter user Scott account unlock;

After unlocking you may be asked for the password: [SQL] View plaincopy alter user Scott identified by Tiger;

Re-login: [SQL] View plaincopy 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.

Complete the demonstration operation:

[SQL] View plaincopy login to Oracle database using System user, enter command: Show user; The result of the command execution is: Displays the currently logged on user.

Sql*plus:release 10.2.0.1.0-production on Sunday March 4 13:54:32 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production with the partitioning, OLAP and Data Mining opt Ions

Sql> Show user; USER is "SYSTEM" sql>

Log in to the Oracle database using the SYS user and enter the 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.

Sql> conn as SYSDBA; Enter the user name: SYS input PASSWORD: * * is connected.

Sql> Show user; USER is "SYS"

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

Sql> Show user; USER is "SYS"

Enable Scott users with SYS: Enter the command:sql> alter user Scott account unlock;

Sql> alter user Scott identified by Tiger;

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

Sql> Show user; USER is "SCOTT" sql>

Use the Oracle command to view all user commands that already exist in the current database as follows:

[SQL] View plaincopy select username from dba_users;

Original from the "Bit network", reproduced please keep the original link: http://soft.chinabyte.com/database/456/12286456.shtml

Ways to start Scott users in Oracle 11GR2