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

alexlake
1317917
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:

GRANT CONNECT TO user1
IDENTIFIED BY new_password;
permanent link

answered 12 Dec '23, 07:51

Chris%20Keating's gravatar image

Chris Keating
7.7k49127
accept rate: 32%

edited 12 Dec '23, 09:50

Reg%20Domaratzki's gravatar image

Reg Domaratzki
7.7k343118

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:

×108
×34

question asked: 12 Dec '23, 04:10

question was seen: 301 times

last updated: 12 Dec '23, 09:51