• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 100
  • Last Modified:

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?
  • 2
1 Solution
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.
holemaniaAuthor Commented:
Thank you.  That make sense.  I will try that and update later.
holemaniaAuthor Commented:
Thank you.  That was it.
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.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now