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

Re: [INTERFACES] Changing User Passwords

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [INTERFACES] Changing User Passwords
Date: 1999-09-23 08:15:33
Message-ID: 8568FC767B4AD311AC33006097BCD3D6014225@woody.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-interfaces
It's on the To-Do list (admittedly not the one on the web site though!). It
got kind of missed as I did all the permissions stuff in the 6.3.x releases
when (as far as I could tell) the concept of groups was only implemented in
as much as a pg_group table existed. Consequently I designed my own system
for our software....
 
Regards,
 
Dave.
 
-- 
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!


-----Original Message-----
From: The Hermit Hacker [mailto:scrappy(at)hub(dot)org]
Sent: 22 September 1999 20:23
To: Dave Page
Cc: 'pgsql-interfaces(at)postgresql(dot)org'
Subject: Re: [INTERFACES] Changing User Passwords



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 @ hub.org 
primary: scrappy(at)hub(dot)org           secondary:
scrappy(at){freebsd|postgresql}.org 

pgsql-interfaces by date

Next:From: Tom JenkinsDate: 1999-09-23 12:22:14
Subject: java.sql.Types problem
Previous:From: Peter MountDate: 1999-09-23 06:21:00
Subject: Re: [INTERFACES] ResultSet.getDate

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