This article is a mirror article of machine translation, please click here to jump to the original article.

View: 12429|Reply: 0

[Source] View the user name and password for the Oracle database

[Copy link]
Posted on 1/24/2015 2:03:03 PM | | | |

cmd

C:Documents and SettingsAdministrator>sqlplus / as sysdba



After logging in with a sysdba account, you can change the password of other accounts
Run cmd and enter the command as follows
SQLPLUS/AS SysDBA --------- Login to SYS Super User (SYSDBA)
alter user username account unlock; --------- Unlock (must be withheld; "No.)
alter user username identified password; ------------- change your password
Then log in with your changed password


If any user can log in, you can know which users are currently using the following methods
Select Distinct Owner from all_objects to view the current user


Oracle has three default usernames and passwords~
1. Username: sys password: change_on_install
2. Username: system password: manager
3. Username: scott Password: tiger





Previous:Oracle Remote Connect DB Configuration connection command
Next:Baidu Search engine has enabled the SSL+HTTP protocol to encrypt transmissions
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.

Mail To:help@itsvse.com