Changing the DBA Password

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

Prerequisites

To change the DBA password, you must have DBA or PERMS ADMIN authority.

If you are using dbisql, it is a good idea to put your permission grants into a command file for reference and so that it can be modified and run again if it is necessary to recreate the permissions.

Task

The user ID DBA identifies a user with full administration and resource creation rights. The following command changes the password for user ID DBA to new_password:

ALTER USER DBA
IDENTIFIED BY new_password