Stored Procedure question

fender80fender80 Registered Users Posts: 7 ■□□□□□□□□□
Hello everyone,

I have a question on running a stored procedure:

If you have a user running a stored procedure on a table on schema .dbo and the stored procedure will not run with an error of user not having "x" permission on the particular table:

Do you give the specific user whatever permissions are needed to perform actions on the table or run the stored procedure as another user with proper permissions? Would you ever run as .dbo (would that even work?)?

This is a paraphrased question I've seen on a practice exam and cannot seem to find an explanation for the answer. Many thanks!


Sign In or Register to comment.