Grant the privilege to execute or call a procedure.
At least one of these conditions:
Procedures execute with the privileges of their owner. Any procedure that updates information on a table executes successfully only if the owner of the procedure has UPDATE privileges on the table.
As long as the procedure owner has the proper privileges, the procedure executes successfully when called by any user assigned privilege to execute it, whether or not he or she has privileges on the underlying table. You can use procedures to allow users to carry out well-defined activities on a table, without having any general privileges on the table.
GRANT EXECUTE ON procedure_name TO usreID