Can't alter password for PUBLIC

[james120]

I am trying to assign passwords to the default accounts, and the syntax in the docs doesn't seem to work for user PUBLIC. I am typing:

ALTER USER PUBLIC IDENTIFIED BY password;

and it says "015 Line 3: syntax error at PUBLIC". The same syntax works fine for the _SYSTEM user.

[james120]

I did that successfully once, and now I don't seem to be able to alter the passwords on either _SYSTEM or PUBLIC. It always says "000 No valid password supplied in the function chpass." I know I am entering the correct passwords, and the system even recongizes them in other contexts (e.g. I can log in as those users -- I just can't change their passwords).

[james120]

By the way, with respect for the need to use "tsql -a C -u PUBLIC" to change the PUBLIC password, note that is does not say anything about that in the password instructions (see page 135-136 of http://www.thunderstone.com/site/texis.pdf). I've come across issues like this many times. It seems that your documentation could use reviewing for errors, ommissions, and things that used to be true, but no longer are in the current version of the database. You guys have been great at quickly answering questions, but if the documentation were better it would save everyone a lot of time because the questions wouldn't need to be asked in the first place.

[james120]

That works. For reference for anyone else who encounters this issue, the exact syntax is:

tsql -a C -u _SYSTEM -p password

where "password" is replaced by the _SYSTEM password. It then asks you for the system password again, and then allows you to enter a new password.

[james120]

(reposting because I had inadvertenly left this as "private" before)

That works. For reference for anyone else who encounters this issue, the exact syntax is:

tsql -a C -u _SYSTEM -p password

where "password" is replaced by the _SYSTEM password. It then asks you for the system password again, and then allows you to enter a new password.