Dear Sir/Madam,
I have a problem regarding grants in PG. It is as follows:
I wanted to grant execute on a function that updates a table.
But i got an ERROR: permission denied for relation <table_name>
Now i don't want to grant update on that table as i want all updates
to be done through the function, and no one should be able to update
it manually.
How can i achieve that?
thanks & Regards,
Rajarshi Mukherjee.