Grant the user permissions on sysudtlib and sysspatial:
create user geouser as perm=1e9 password=geouser; grant all on dbc to geouser with grant option; grant all on sysudtlib to geouser with grant option; grant all on sysspatial to geouser with grant option;
The following figure shows the permissions required for a user of ST_Geometry column.
Grant Permissions Using BTEQ Example