IDEA: "suid" functions - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject IDEA: "suid" functions
Date
Msg-id 20020120102223.B30153@depesz.pl
Whole thread Raw
List pgsql-general
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]

pgsql-general by date:

Previous
From: Masaru Sugawara
Date:
Subject: Re: failure to always use index on similar databases with eual queries
Next
From: Andrew Gould
Date:
Subject: frustration with database size