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?
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.