I have built a collection of procedures which act on a number of
tables. These work successfully using the "sa" user and now i want to
use a new user to execute the packages and modify the data (DML).
For my new database i have enabled the db_datareader and db_datawriter
options but i cannot work out how to allow the new user to execute any
procedure under the new database.
I have given specific permissions to the procedure for that user and
it now (permission) errors execute a proc in the master db.
Can someone explain what is going ...