agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedReassign permissions
2+ messages / 2 participants
[nested] [flat]
* Reassign permissions
@ 2015-08-25 19:20 Amreen Khan <amreenkhan@hotmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Amreen Khan @ 2015-08-25 19:20 UTC (permalink / raw)
To: pgsql-sql
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 =
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Reassign permissions
@ 2015-08-25 20:46 Rene Romero Benavides <rene.romero.b@gmail.com>
parent: Amreen Khan <amreenkhan@hotmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Rene Romero Benavides @ 2015-08-25 20:46 UTC (permalink / raw)
To: Amreen Khan <amreenkhan@hotmail.com>; +Cc: pgsql-sql
How about defining it with the SECURITY DEFINER modifier?
2015-08-25 14:20 GMT-05:00 Amreen Khan <amreenkhan@hotmail.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/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-08-25 20:46 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-08-25 19:20 Reassign permissions Amreen Khan <amreenkhan@hotmail.com>
2015-08-25 20:46 ` Rene Romero Benavides <rene.romero.b@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox