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
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
