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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ted Taylor | 2004-09-17 15:32:47 | Re: Error adding new column to existing table. |
Previous Message | Andreas Pflug | 2004-09-17 14:40:13 | Re: Error adding new column to existing table. |