The forum is currently being migrated to a new host. While the migration happens, the old server is still available. Once the new machine is ready, I will copy the database to the new machine. Feel free to ask and answer questions in the meantime.

After creating an user with "FORCE PASSWORD CHANGE ON" or using dual control to change the DBA password I get in DBISQL or SQL Central a dialog window asking me for the old and new password.

Using isql, "DBISQL -nogui" (, or SQuirreL SQL) I only get a message that the password has expired but no dialog (). Is there a possibility to change the password with another tool or must I use DBISQL with gui or SQL Central?

Many thanks

asked 15 May '19, 04:57

Robert%20Kratschmann's gravatar image

Robert Krats...
964410
accept rate: 0%


with "-nogui" obviously you won't get a dialog. You should be able to use the "newpassword" / "newpwd" connection parameter to specify the new password on the cmd line.
For SQuirreL SQL, I'd expect a dialog to pop up if you use the JNI JDBC driver aka iAnywhere JDBC driver or a JDBC-to-ODBC bridge. I doubt that jConnect supports this. This, however, is educated guessing, I can't currently verify or falsify it.

HTH

Volker

permanent link

answered 15 May '19, 05:49

Volker%20DB-TecKy's gravatar image

Volker DB-TecKy
5453715
accept rate: 25%

edited 15 May '19, 07:25

Hi Volker,

many thanks "newpwd" works fine with DBISQL and also in SQuirrel SQL.

Additional information: I did a test with dual control and offline DBA password reset...

It works too but you have to change the password twice:

...
CONNECT TO test USER U1 IDENTIFIED BY sybase;
ALTER USER DBA IDENTIFIED FIRST BY part11;
CONNECT TO test USER U2 IDENTIFIED BY sybase;
ALTER USER DBA IDENTIFIED LAST BY part22;
STOP SERVER UNCONDITIONALLY;

--U:\>"%SQLANY17%\bin64\dbeng17.exe" -orp "UID=DBA;NEWPWD=newpassword;AUTHUID=DBAReset;AUTHPWD=sybase" d:\dualcontrol.db
--Password for user 'DBA' is reset sucessfully

START SERVER AS test STARTLINE 'C:\\Program Files\\SQL Anywhere 17\\bin64\\dbeng17.exe -c 10M d:\dualcontrol.db';
CONNECT USING 'UID=DBA;PWD=newpassword;NEWPWD=sybase;Server=test';
CONNECT TO test USER DBA IDENTIFIED BY sybase;
select * from sysusers;--OK

Maybe it would be better if offline DBA password reset is not allowed if dual control is used?

(15 May '19, 08:23) Robert Krats...
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×33
×14

question asked: 15 May '19, 04:57

question was seen: 450 times

last updated: 15 May '19, 08:35