Hi guys,
I´m almost sure that this question has been asked before... but
after a 2 days search, I couldn´t find any solutions for it, I´m a noob to
postgres, but manage to install version-7.3.4 no prob, and working fine. So
here goes:
I´m looking for a way to store procedures on the db so that i can only
access data through those, and only grand permissions to the user to
access the procedures and not the tables. I´ve read some stuff about setuid
in this mailing list but could not get it to work. Basically what i need is
to give privilege to the function to access the tables that will be used and
is not granted to the user that executed the function.
Any help will be very much appreciated, even if there is no way of doing
so :)
Thanks
Iandé