Changing the DBA Password

Change the password for the DBA user. The default password for DBA user for all databases is sql. You should change this password to prevent unauthorized access to your database.

Prerequisites

Requires the CHANGE PASSWORD system privilege.

Note: If you are using dbisql, it is suggested that you place your permission grants into a command file for reference so you can modify and re-run it if necessary, to re-create the permissions.

Task

To change a user password, execute:

ALTER USER userID
IDENTIFIED BY password

Example:

This example changes the DBA user password to S&cureAdm1n:

ALTER USER DBA
IDENTIFIED BY S&cureAdm1n