24.4.1 DBA privilege setup

A DBA privilege holder uses the GRANT statement to grant DBA privileges to other users. DBA privileges cannot be granted to roles. Specify in the GRANT statement's IDENTIFIED BY operand the passwords that are registered in the Directory Server. Check that a password is specified for every user.

When DBA privilege is granted, that information is registered in SQL_USERS.

Example
Grant DBA privilege to the user whose authorization identifier is USR01 and password is HIR01:

GRANT DBA TO USR01 IDENTIFIED BY HIR01