Hi,
I'm implementing a database with very 'restrictive'
privileges. However I've hit a dead end trying to
solve one issue.
When GRANTing execute to a plpgsql function it
appears to run with the priviledge of the user and
NOT with the priviledges of the owner of the function.
This is causing a problem as within the function
an insertion into a table owned by the function owner
is required.
It's not acceptable to grant INSERT on this table
for the function executor as the whole point is about
controlling access to the table within the function.
Does anyone have any suggestions as to what I may be
doing wrong? (Or how can I do it better?)
This is with postgresql 7.3.4
Many thanks,
-Greg
--