| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | "Lars Preben S(dot) Arnesen" <l(dot)p(dot)arnesen(at)usit(dot)uio(dot)no> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: User permissions |
| Date: | 2002-03-14 15:47:46 |
| Message-ID: | 20020314074530.O433-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 14 Mar 2002, Lars Preben S. Arnesen wrote:
> [ Stephan Szabo ]
>
> > Well, I'm not sure you can using only pl/pgsql, but if you don't grant
> > access to any of the tables, I know that in C you can have functions run
> > queries as a different user.
>
> This sounds interesting. Is there any simple examples for doing stuff
> like this?
Well, it involves SPI stuff and I think there's some docs on that and
examples floating around. In the referential integrity triggers it
sets the user to the owner of the table that it's scanning
(backend/utils/adt/ri_triggers.c) but I wouldn't call that stuff
simple really.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2002-03-14 15:49:13 | Re: JDBC Prepared Statement Bug |
| Previous Message | Doug McNaught | 2002-03-14 15:47:38 | Re: location of Large Object |