Skip to Content

Change server password IQ16.

Good day everyone,

Is there a way to change the IQ server password?

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 12, 2015 at 05:58 PM

    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

    Add comment
    10|10000 characters needed characters exceeded