Shulou(Shulou.com)05/31 Report--

This article will explain in detail the example analysis of database connections for sys, system and Scott users in Oracle. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

System default: manager

Sys default: change_on_install

When logging in to the database using SQL Plus, system can log in directly using the password manager.

Since I changed my password for myself, my password is not logged in using manager, but the code format is still similar.

Code example:

Conn system input password: 1234conn system/ enter password

However, if you are a sys user, the password must be as sysdba, that is, the full password is: change_on_install as sysdba

Code example:

Conn sys/change_on_install as sysdbaconn user sys/ password

Connect to scott users and log in directly with a password using tiger. [this applies only to settings where you have not changed the Scott user password]

Code example:

Conn scott/1234conn user scott/ password "sample analysis of database connections under sys, system and Scott users in Oracle" ends here. I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.