gpsingh meant:

grant execute procedure_xyz to dba;

Not thru the role you are trying...