For step-by-step instructions on how to do this, see To view or modify permissions to execute all procedures of a namespace and To view or modify permissions to execute a procedure.