cancel
Showing results for 
Search instead for 
Did you mean: 

Change server password IQ16.

former_member214071
Participant
0 Kudos

Good day everyone,

Is there a way to change the IQ server password?

Thanks in advance

Accepted Solutions (1)

Accepted Solutions (1)

markmumy
Advisor
Advisor
0 Kudos

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'
  • sp_iqpassword

Here's the doc link to changing the DBA password:  Changing the DBA Password

Mark

former_member214071
Participant
0 Kudos

Correct Mark,  that's the right term.    Thanks.

Answers (0)