- Privileges Management
This document explains the procedure for changing the password of the sys account.
ALTIBASE HDB version 4 or later
To change the password for the sys account, follow the three steps below.
1. Execute the alter user command
Connect to the Altibase server as the sys user and change the password with the alter user command.
2. Execute altipasswrd
Execute while the Altibase server is online.
3. Modify the script containing the sys password
The three scripts below contain the sys password.
So, when changing the sys password, these scripts also need to be modified.
Change the password after the -p option in the $ALTIBASE_HOME/bin/server script to the new password.
Change the password after the -p option in the $ALTIBASE_HOME/bin.ls script to the new password.
Change the password after the -p option in the $ALTIBASE_HOME/bin/il script to the new password.
What to do if an "Invalid password" error occurs when starting the server
a. Open the $ALTIBASE_HOME/bin/server script and check if the password has been modified in the lower part.
b. If an invalid password error occurs even though the above a is applied with the changed password, it is possible that the sys password was changed only with the alter user command and altipasswd was not executed.
In this case, execute altipasswd, apply the changed password, and then try to start the server.
DBA Privilege Management (System Privilege Restriction)
ALTIBASE HDB does not have the same function as Oracle's Role.
Check the privileges of the database user and delete any unnecessary system privileges.
How to check
How to manage
Using WITH GRANT OPTION
With WITH GRANT OPTION, the user who has been granted object access privileges can grant the appropriate privileges to other users, so object access privileges can be abused without DBA management.