Hi Mike,

I get exactly the same problem when I give it a whirl on Ingres2006. II
9.0.4 (a64.lnx/105)NPTL + patch12343

It still fails when I give the specific user the 'maintain_users'
privilege -- which is not something I'd want to do!

I'd suggest that this is some form of bug.

Martin Bowes

-----Original Message-----
From: info-ingres-bounces@kettleriverconsulting.com
[mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of
mr.rude@gmx.net
Sent: 28 September 2007 08:59
To: info-ingres@kettleriverconsulting.com
Subject: [Info-Ingres] User can't change its password

Hello,

I've the latest Ingres Community Edition running and now I tried to
change the password of a user, but it did not succeed. I'm doing the
following:

- Log on to the linux system as user 'foobar'
- $sql iidbdb
- alter user foobar with oldpassword='test', password='test2'; \g

The answer of the system is:

"You do not have privileges to issue this form of 'ALTER USER/PROFILE'
statements."

But why do I get this message? In the Documentation (SQL Ref.) it
says:

"You must be connected to the iidbdb database. The maintain_users
privilege is
required, except for users who simply want to change their own
password. You
must have maintain_audit privileges to change security audit
attributes."

My case is the one whre a user simply wants to change its own
password. So I don't need any privileges for my user 'foobar' to do
this.

Do you have any Idea what I'm doing wrong?

Thanks in advance

Michael

_______________________________________________
Info-Ingres mailing list
Info-Ingres@kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres