In Oracle, it's possible to connect to the database without specifying a password if the user account on the machine where the DB is running is a member of the DBA group.
Then it will be possible to reset the password for any user (even SYS); this is especially useful if you forgot what your password was. First, connect to the machine where the DB is running then open a command prompt and type:
SQLPLUS / AS SYSDBA
to log in, then type
ALTER USER USER_NAME IDENTIFIED BY "NEW_PASSWORD";
to change the password for USER_NAME
No comments:
Post a Comment
With great power comes great responsibility