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, 04:57

Robert%20Kratschmann's gravatar image

Robert Krats...
81118
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, 05:49

Volker%20DB-TecKy's gravatar image

Volker DB-TecKy
4703513
accept rate: 28%

edited 15 May, 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, 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:

×28
×12

question asked: 15 May, 04:57

question was seen: 107 times

last updated: 15 May, 08:35