Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Changing User Passwords

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [INTERFACES] Changing User Passwords
Date: 1999-09-22 20:22:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
One thing I found lacking, or just couldn't find...the ability to
grant/revoke group permissions?  Just something I'm missing, or just not
implemented yet?

On Wed, 22 Sep 1999, Dave Page wrote:

> 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.
> ************

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ 
primary: scrappy(at)hub(dot)org           secondary: scrappy(at){freebsd|postgresql}.org 

In response to

pgsql-interfaces by date

Next:From: Nuchanach KlinjunDate: 1999-09-23 02:35:04
Subject: Re: [INTERFACES] ODBC-Interfaces - connection options ? Error !
Previous:From: Herouth MaozDate: 1999-09-22 16:51:01
Subject: RE: [SQL] Re: [INTERFACES] JDBC and getting just assigned serial number

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group