Re: Login as different user inside of a function.

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