| From: | Rene Romero Benavides <rene(dot)romero(dot)b(at)gmail(dot)com> |
|---|---|
| To: | Amreen Khan <amreenkhan(at)hotmail(dot)com> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Reassign permissions |
| Date: | 2015-08-25 20:46:31 |
| Message-ID: | CANaGW09XYaFv9yT8mhGjc=xXmZ0iSDH+8Nq9j1uMr1Xg4r4P+Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
How about defining it with the SECURITY DEFINER modifier?
2015-08-25 14:20 GMT-05:00 Amreen Khan <amreenkhan(at)hotmail(dot)com>:
> I had a function that a group owns, I'm part of this group. I wanted to
> change the permissions or give grant delete privileges to session_user. And
> another group of users was granted all privileges on the function in order
> to be able to run it. My group still wants to own the function but we want
> whoever runs the function outside of our group to be able to have delete
> privileges on a table that is created within the function. Does anyone have
> any suggestions?
>
> *Amreen Khan *
>
--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Nelson | 2015-09-11 14:46:25 | Showing a cumlative total by month |
| Previous Message | Amreen Khan | 2015-08-25 19:20:43 | Reassign permissions |