How to start Scott user in Oracle

The method for starting Scott user in Oracle. In Oracle10g, (g stands for 'network') the Scott user in the database is locked during installation. When installing Oracle, you can directly unlock the user. If you forget to unlock the user, you can use the sqlplus tool to unlock the user by using commands later.

The scott user is locked by default. Unlock the user to log on to the database.

Use the following statement to unlock scott:

1. Alter UserScott account unlock;

This password may be required after unlocking:

1. Alter UserScott identifiedByTiger;

Log On again:

1. Sqlplus scott/tiger

Then you can log on.

Note:

To enable the account with the command line, you must set a password after unlocking the account. Otherwise, you still cannot log on and submit the account.

Complete the demo operation:

1. Log on to the Oracle database using the system user and enter the command: showUserThe command execution result is: the user currently logged on is displayed.
2. SQL * Plus: Release 10.2.0.1.0-ProductionOnSunday March 4 13:54:32 2012
4. Copyright (c) 1982,200 5, Oracle.AllRights reserved.
7. Connect:
8. OracleDatabase10g Enterprise Edition Release 10.2.0.1.0-Production
9. WithThe Partitioning, OLAPAndData Mining options
11. SQL> showUser;
12. USERIs"SYSTEM"
13. SQL>
15. Log on to the Oracle database using the sys user and enter the command: connAsSysdba; after the command is executed, the system prompts: Enter the user name, and then enter the password. After the system checks the correct information, you can connect.
16. SQL> connAsSysdba;
17. Enter the User name: sys
18. Enter the password :****
19. Connected.
20. SQL> showUser;
21. USERIs"SYS"
23. Use showUserCommand to view the user currently logged on.
24. SQL> showUser;
25. USERIs"SYS"
29. Use sys to enable Scott User: Enter the command:
30. SQL>Alter UserScott account unlock;
31. The user has changed.
33. SQL>Alter UserScott identifiedByTiger;
34. The user has changed.
36. SQL> conn scott;
37. Enter the password :*****
38. Connected.
39. SQL> showUser;
40. USERIs"SCOTT"
41. SQL>

Use the Oracle command to view all existing users in the current database:

1. SelectUsernameFromDba_users;

Over !!!