How can I modify the username and password of the oracle database ?, Oracle Database

How can I modify the username and password of the oracle database ?, Oracle Database

It is common for students who do not frequently use databases to forget their usernames and passwords. Here we will introduce how to modify the username and password of the oracle database.

Go to the cmd command interface (the shortcut key is win + R ).

Change the administrator user password (1): Enter sqlplus "/as sysdba" on the command interface to successfully connect to the Administrator identity.

Modify the administrator password (2): Enter

Alter user system identified by 123456;

This command is used to set the password of the administrator user system to 123456.

Change the password of a common user (1): You must first link the user as an administrator. On the command interface, enter sqlplus "/as sysdba" to connect the user as an administrator.

Change the password of a common user (2): enter the password on the SQL command INTERFACE

Alter user username identified by 123456;

This command sets the password of the administrator user username (User username created earlier) to 123456.

Now you can connect to the database through the administrator user and common user. Open the cmd command again, enter sqlplus on the command interface, prompt to enter the user name, and then enter the modified password.