It seems that in PG a plpgsql function operates with the access privileges of the connected user. In Oracle, and others, the function can have the privileges of the user that compiled it so that any user with an execute privilege on the function can execute it without running into permission violation. Do you know of a way to provide such implicit privileges in PG?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.