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

Re: allowing users to change the IP-addresses that

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: stig erikson <stigerikson_nospam_(at)yahoo(dot)se>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: allowing users to change the IP-addresses that
Date: 2004-09-17 14:43:45
Message-ID: 414AF821.8020507@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
stig erikson wrote:
> Hello.
> I have a postgresql 7.4.5 running.

This list is for pgadmin, not for pgsql.

> On the server i have a few databases, all owned and administered by 
> different users.
> The users sometimes change access-rules to their databases, in 
> particular they change access rules based on IP-addresses, which i have 
> to do for them manually in pg_hba.conf.
> 
> is there some way to avoid the pg_hba.conf-file?
> optimally i would like the access rights to be stored with the user 
> and/or the database and tables. is this possible?
> thus allowing users to change access rights themselfs.
> 
> if it is not possible in 7.4.5, is it planned for 8.0?

No. I'd recommend using groups for that, i.e. don't use "all all" in 
pg_hba.conf, but "mydb-to-protect +group-who-may-access"

Regards,
Andreas

In response to

pgadmin-support by date

Next:From: Ted TaylorDate: 2004-09-17 15:32:47
Subject: Re: Error adding new column to existing table.
Previous:From: Andreas PflugDate: 2004-09-17 14:40:13
Subject: Re: Error adding new column to existing table.

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