|
Using the GRANT statement, you can change your password or that of another user if you have DBA authority. For example, the following command changes the password for user ID M_Haneef to new-password:
GRANT CONNECT TO M_Haneef IDENTIFIED BY new-password;
The default password for the DBA user for all databases is sql. You should change this password to prevent unauthorized access to your database. The following command changes the password for the DBA user to new_password:
GRANT CONNECT TO DBA IDENTIFIED BY new_password;