Thread: IDEA: "suid" functions

IDEA: "suid" functions

From
hubert depesz lubaczewski
Date:
hi
is there any chance that there will be function with "suid"
possibilities?
i mean: i want to be able to:
1. have table a with right only to user "owner"
2. function setSoemthing(text) which update's table a
3. function setsomething is owner by user "owner", but i gave rights to
execute it to user "miner"
4. user miner, despite cannot directly select * from a, can select
setSomething('bleble'), and this will work.

any idea on how to do so or if this will be introduced in some future
release of PostgreSQL?

depesz

--
hubert depesz lubaczewski                          http://www.depesz.pl/
------------------------------------------------------------------------
... vows are spoken to be broken ...                 [enjoy the silence]
... words are meaningless and forgettable ...             [depeche mode]