1. Open SQL Developer, create a new SYS connection (SYS has the highest privileges for system administrators):
2. Create a new system connection (System is local administrator with sub-high permissions):
3. New Scott (Scott is a normal user, unlocked by default) connection:
The default Scott user is locked, so to log in to the Administrator account unlocks:
After unlocking the Scott account, connect using the Scott account's default password:
For security reasons, the default account password is valid for 180 days, which can be resolved by modifying the default validity period, or by modifying the Scott account password with the following statement:
Alert user Scott identified by ********;
After the password has been modified, the connection is successfully established.
4. Create your own account and establish a connection:
4.1 Create a Yongfeng account and authorize
4.2 Establishing a connection to the Yongfeng account
SQL Developer New Connection