Procedures are generally executed with privileges assigned to the creator of procedure and not with the privileges available to the user executing the procedure.
Was the procedure created in dev schema? if not, the user in whose schema the procedure exists must be given privilege for the tables referenced by the procedure.