IDEA: "suid" functions

From: hubert depesz lubaczewski <depesz(at)depesz(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: IDEA: "suid" functions
Date: 2002-01-20 09:22:23
Message-ID: 20020120102223.B30153@depesz.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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]

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gould 2002-01-20 13:12:04 frustration with database size <long>
Previous Message Masaru Sugawara 2002-01-20 08:29:22 Re: failure to always use index on similar databases with eual queries