Question On authid current_user

From: Scott Canaan <>
Date: Mon, 21 Jan 2013 09:57:25 -0500
Message-id: <>


   I created a stored procedure that analyzes the tables in a small schema. The procedure is owned by one user and was created with authid current_user, so it can be run by another user. It runs fine as the other user, as long as it is called directly by that user. When it is put inside a package, an ORA-01031: insufficient privileges error is raised. The customer is asking me to grant "execute any" privilege to the second user so that it will run. I'm not convinced that will solve the problem and I don't want to do this grant. What other options are there for getting this procedure to run inside the package? Scott Canaan '88 (<>) (585) 475-7886 - work (585) 339-8659 - cell "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.

Received on Mon Jan 21 2013 - 15:57:25 CET

Original text of this message