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....
Network & Systems Manager, The Vale Housing Association.
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
From: The Hermit Hacker [mailto:scrappy(at)hub(dot)org]
Sent: 22 September 1999 20:23
To: Dave Page
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
On Wed, 22 Sep 1999, Dave Page wrote:
> 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
> is with ALTER USER, but of course this fails (as shown in the snippet from
> valesoft=> alter user jbeirne with password xxxx;
> ERROR: alterUser: user "jbeirne" does not have SELECT and UPDATE
> for "pg_shadow"
> Any ideas would be appreciated...
Marc G. Fournier ICQ#7615664 IRC Nick:
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary:
pgsql-interfaces by date
|Next:||From: Tom Jenkins||Date: 1999-09-23 12:22:14|
|Subject: java.sql.Types problem|
|Previous:||From: Peter Mount||Date: 1999-09-23 06:21:00|
|Subject: Re: [INTERFACES] ResultSet.getDate |