Stored Procedure question

fender80fender80 Posts: 7Registered Users ■□□□□□□□□□
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!

Comments

Sign In or Register to comment.