Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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...
1166715
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:

×37
×15

question asked: 15 May '19, 04:57

question was seen: 1,236 times

last updated: 15 May '19, 08:35