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.

Inherited an old ASA10 DB that I need to change a password on. ALTER USER doesn't seem to work. Was there some strange way that one did this?! Also, is there a copy of the manual available online?

asked 12 Dec '23, 04:10

alexlake's gravatar image

accept rate: 11%

Also, is there a copy of the manual available online?

The "Document Comment Exchange" page has the full doc set of SQL Anywhere starting with 10.0.1. Note, the page will be closed soon but the SAP Help Portal does also offer the 10.0.1 help.

(12 Dec '23, 08:25) Volker Barth

To change a password, use GRANT CONNECT with the new password. For example:

IDENTIFIED BY new_password;
permanent link

answered 12 Dec '23, 07:51

Chris%20Keating's gravatar image

Chris Keating
accept rate: 31%

edited 12 Dec '23, 09:50

Reg%20Domaratzki's gravatar image

Reg Domaratzki

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 12 Dec '23, 04:10

question was seen: 510 times

last updated: 12 Dec '23, 09:51