Oracle - Stored Procedure Privilge access

So I created a stored procedure to insert/update some other tables.  After creating the stored procedure and compiling it, I am getting error that I do not have access.  However, I am able to update/insert to those tables with just the query before making the SP.  Is there anything special that needs to be done to allow the SP to update those tables?
holemaniaAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
the stored procedure needs to be owned by the same schema that owns the tables

or, that schema needs to be granted insert/update privileges on those tables directly (i.e. NOT through a role)


another option, probably not what you want...

that procedure could be recompiled with "authid current_user" option, but using this route generally complicates things.
0
 
holemaniaAuthor Commented:
Thank you.  That make sense.  I will try that and update later.
0
 
holemaniaAuthor Commented:
Thank you.  That was it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.