I had a function that a group owns, I'm part of this group. I wanted to change the permissions or give grant delete privileges to session_user. And another group of users was granted all privileges on the function in order to be able to run it. My group still wants to own the function but we want whoever runs the function outside of our group to be able to have delete privileges on a table that is created within the function. Does anyone have any suggestions?
Amreen Khan