Hi,
Using pg_shadow based passwords I'm having trouble figuring out how a user
can change their own password via ODBC. The only way I can see of doing this
is with ALTER USER, but of course this fails (as shown in the snippet from
psql)
valesoft=> alter user jbeirne with password xxxx;
ERROR: alterUser: user "jbeirne" does not have SELECT and UPDATE privilege
for "pg_shadow"
Any ideas would be appreciated...
Regards,
Dave.