The database system administrator’s password can be changed with the ALTER USER command. The administrator’s user name cannot be changed with the ALTER USER command; the user name can be changed by granting the SYS_ADMIN_ROLE to another user and then dropping the original administrator user account.
About this task
The database system administrator account is created when the solidDB® database is created. The creator of the database has the SYS_ADMIN_ROLE user role.
Note You must remember your user name and password to be able to connect to solidDB®. There are no default user names. The administrator user name you enter when creating the database is the only user name available for connecting to the new database for the first time. If you cannot connect to solidDB® because you have forgotten your system administrator user name or password, contact UNICOM Systems, Inc. Support.
Changing administrator's password
To change the administrator’s password, issue the following command:
ALTER USER username identified by new_password
Changing administrator's user name
To change the administrator’s user name:
1 Create a user with the following command:
CREATE USER username IDENTIFIED BY password
2 Grant the new user the SYS_ADMIN_ROLE role with the following command:
GRANT SYS_ADMIN_ROLE TO username
3 Drop the original administrator account with the following command: