Kris Kiger wrote:
> Here's my problem. I have user X calling a database function. The
> function inserts data into table Y. User X only has select access to
> this table. Is there some way to allow user X to call a function that
> does an insert for him/her without user X having to have write access to
> table Y? Is it possible to log in as another user inside of a function?
> Thanks for the help!
>
> Kris
If you are using 7.3 or later you can create the function using SECURITY
DEFINER.
hth,
- Stuart