Oracle logs on with Scott users

Oracle has 3 types of users:

System, SYS, Scott, where system and SYS differ in the ability to create databases, the SYS user logs in to create a database, and Scott is the user who learns from the novice, who can log on to the system with Scott, noting that after the Scott user logs in, You can use Oracle-provided databases and datasheets, which are provided by Oracle, and learners do not need to create their own databases and datasheets to practice SQL directly using these databases and data tables

OK, we open sql*plus, log in with Sys

Note By default, the Scott user is locked, so we have to log in with the SYS user and then unlock it.

Conn/as SYSDBA

SYS login, you can unlock the

Alter user Scott account unlock

OK, log in with the Scott user

Conn Scott/tiger

Note that the passwords are all Tiger's!

At this point we can use Show user to view the logged in user, Scott can directly practice

Show user

Enter show EMP, test, can show instructions for login success, can be practiced, EMP is a data table provided by Oracle

Show EMP;

Oracle logs on with Scott users