Q. Why do I have to give permissions on the underlying database objects when I’m using dynamic SQL statements?
A. These permissions are required for security reasons. Consider the following simple stored procedure:
Read More - Register for Free Membership