Change server password IQ16.
Good day everyone,
Is there a way to change the IQ server password?
Thanks in advance
Mark Mumy replied
I assume that you mean the DBA password?
During database creation you can add the key phrase: DBA PASSWORD password.
You can also change the name of the DBA account during creation with the key phrase: DBA USER userid
There have been some cases recently on changing the user name for DBA, so I would stay away from that for the time being.
If the database has already been created, then you can simply run any of the following:
- GRANT CONNECT to DBA identified by 'new_password'
- ALTER USER DBA identified by 'new_password'
Here's the doc link to changing the DBA password: Changing the DBA Password