Hi,
There is a procedure named 'Update_emp_details' in our database which actually update the employees table present in the same database. I needs to give execute permission for a another user to this procedure 'Update_emp_details'.
Is giving execute privilege is enough for that user to run the procedure 'update_emp_details' or should i also needs to give modify privileges(insert,update,delete) for the table 'employees' ?
Please clarify me.