You dont need resource privilege...connect privilege is sufficient for your purpose(if you want only query and update data)

The error you are receiving means you have wrong syntax in your statement.
You can't use "on all table" keyword...informix has no support for it. Instead you have to grant privileges individually for every table you want...with shell script for example.
Find out solution to this problem on this forum...it was already solved.