Oracle forgot user password operation query DBA Authority ____oracle

If you do not know the password for the System,sys user in Oracle, you can retrieve it as follows:

First, the database is entered as a regular user:
Execute the following command in Sql*plus:
Sql>connect/as Sysdba (can also be connected in the following way: Sql>connect internal)
Sql>alter user sys identified by SYS; (The password for user sys will change to SYS after carriage return)
Similarly, you can change the system password
Sql>alter user system identified by system; (The password for user system will be changed to system) after carriage return

sql> alter user Scott account unlock (Unlock command)

Using the operating system certification

Conn/as SYSDBA

To modify the password for SYS

Test OK under windows

Oracle®database Express Edition Getting Started Guide
10g Release 2 (10.2)

-----------------------------------------------------------------------------------------------------

Enter SELECT * FROM V$pwfile_users with DBA login. You can query which user DBA or SYSDBA permissions.