• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 96
  • 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?
0
holemania
Asked:
holemania
  • 2
1 Solution
 
sdstuberCommented:
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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