The stored procedures are not able to use privileges granted via roles, so if that's the case, grant privileges directly to the user or define the procedure with invoker rights