Oracle logs on with Scott users

Oracle has 3 types of users:

System, SYS, Scott, where the difference between system and SYS is with the ability to create a database, the SYS user is able to log in enough to create a database, and Scott is the user who learns from the beginning of the learning. The learner can log on to the system with Scott, noting that the Scott user is logged in to be able to use Oracle-provided databases and datasheets, which are provided by Oracle. Learners do not need to create their own databases and data tables, and use these databases and data tables to practice SQL

OK, let's open the Sql*plus. Log in with Sys

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

Conn/as SYSDBA

SYS after logging in. You can unlock it, huh?

Alter user Scott account unlock

Ok. Log in with a Scott user

Conn Scott/tiger

Note that password are all Tiger's.

At this point we can use Show user to view the logged in user. It was Scott who was able to practice directly.

Show user

Enter show EMP. Test. Ability to display instructions login successful, be able to practice, EMP is a data table provided by Oracle

Show EMP;

Oracle logs on with Scott users