| From: | Maciej Sieczka <tutey(at)o2(dot)pl> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Richard Huxton <dev(at)archonet(dot)com> |
| Subject: | Re: how to auto GRANT custom ACL on a new table? |
| Date: | 2008-03-01 22:33:53 |
| Message-ID: | 47C9D9D1.3060102@o2.pl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Maciej Sieczka pisze:
> Richard Huxton pisze:
>> 1. Add a proxy in front of PostgreSQL and have it intercept the CREATE
>> TABLE statements and follow them with the correct GRANT statements.
>> I'd probably modify the code for pgpool/pgbouncer (http://pgfoundry.org/)
> That should do it seems! Thanks a lot!
Dear All
Said too soon, not carefully reading Richard's words first: "probably
modify the code" - I'm no programmer (only shell, awk and some python
savvy).
Isn't there a ready to use sort of addon for PgSQL which could intercept
the CREATE TABLE that eg. Base (or any other client) issues, appdend
GRANT to it and forward such a modified instruction to the server?
I looked a lot in list archives, PgFoundry, Google and can't find a
tool. Your hints are more than welcome!
Best
Maciek
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Rich | 2008-03-01 23:02:24 | Re: Efficiently storing a directed graph |
| Previous Message | Peter Brawley | 2008-03-01 22:29:06 | Re: Efficiently storing a directed graph |