Oracle database pre-defined account (Sys,system,sysman,dbsnmp,scott)

1. SYS user and System user

With the SYS user login needs to sysdba role login, so when entering the password in the password after adding as SYSDBA.

	SYS	SYSTEM
Status	A super User of Oracle	Oracle default system administrator with DBA Authority
Main role	Primarily used to maintain system information and manage instances	Users, permissions, and storage that are typically used to manage Oracle databases
Login role	Only login with SYSDBA or sysoper roles	Can only be logged in normal mode

2. Scott Users

SCOTT. is the name of a sample user in the Oracle database. The default password is Tiger, which is used to provide beginners with some simple application examples, but it is locked by default. Therefore, the user should be unlocked first, (Take Stu user as an example)

[SQL]View PlainCopyprint?

1. Alter user Stu account unlock;

The user's password period will be found after unlocking, so the user will be reset the password.

[SQL]View PlainCopyprint?

1. Alter user Stu identified by [password set];

This allows the Scott user to use four default tables (Bouns, DEPT, EMP, Salgrade),

3, the password back

Sometimes the password is remembered, what to retrieve, first to use SYS or system users to connect to the data inventory, you can change the other users arbitrarily. As long as the control input sqlplus, the user entered the Oracle login, enter the user name: directly enter the System/as sysdba, do not enter the password, the direct return can connect to the database, and then use the Alter user name identified by password To change the password.

Oracle database pre-defined account (Sys,system,sysman,dbsnmp,scott)