Please provide some tool/program that I can execute to change the default
password. We are planning to load confidential data on a hosted server and
can't afford to keep the default password.
Thanks,
On Dec 4, 2007 3:19 AM, Fabian Groffen
On 03-12-2007 16:34:40 -0500, Venks wrote:
How can I change the default MonetDB password? ALTER USER on "monetdb" gives me the following error:
!InvalidCredentialsException:setPassword:The administrator cannot set its own password, use changePassword instead
This is an interesting one. In order to change your password using changePassword, one needs to have the old password. The kernel doesn't allow root to unconditionally change the administrator password (what it does for other users when the administrator uses setPassword).
You can change the administrator/monetdb password using changePassword in the MAL interface. Maybe we should make a little tool/howto for this. I cannot find the wrapper function that used to be there to call for these functions from MAL.