Normally, you shouldn't have to change anything else. Have you tried to connect to the DB with your new user from the oracle sqlplus and did a "select * from <your_table_name>" ?
Thanks, Alan On July 14, 2010 08:07:05 am David Alda Fernandez de Lezea wrote: > Hi list, > > We were working with mapserver 5.6.1 and oracle spatial, and we have change > the user (the new one has less privileges - it cannot modify anything > stored in the DB) that connects to oracle spatial, and now we cannot > connect to the layers stored in oracle. We get the following message: > > [Wed Jul 14 14:01:29 2010].755000 CGI Request 1 on process 2648 > [Wed Jul 14 14:01:30 2010].380000 msOracleSpatialLayerGetItems(): Query > error. Cannot retrieve column list [Wed Jul 14 14:01:30 2010].380000 > msDrawMap(): Image handling error. Failed to draw layer named > 'provincias'. [Wed Jul 14 14:01:30 2010].380000 mapserv request processing > time (msLoadMap not incl.): 0.625s [Wed Jul 14 14:01:30 2010].380000 > msFreeMap(): freeing map at 019AB590. [Wed Jul 14 14:01:32 2010].520000 > CGI Request 1 on process 1924 > [Wed Jul 14 14:01:32 2010].661000 msOracleSpatialLayerGetItems(): Query > error. Cannot retrieve column list [Wed Jul 14 14:01:32 2010].661000 > msDrawMap(): Image handling error. Failed to draw layer named > 'provincias'. [Wed Jul 14 14:01:32 2010].661000 mapserv request processing > time (msLoadMap not incl.): 0.141s [Wed Jul 14 14:01:32 2010].661000 > msFreeMap(): freeing map at 019AB590. [Wed Jul 14 14:01:33 2010].36000 CGI > Request 1 on process 2408 > [Wed Jul 14 14:01:33 2010].161000 msOracleSpatialLayerGetItems(): Query > error. Cannot retrieve column list [Wed Jul 14 14:01:33 2010].161000 > msDrawMap(): Image handling error. Failed to draw layer named > 'provincias'. [Wed Jul 14 14:01:33 2010].161000 mapserv request processing > time (msLoadMap not incl.): 0.125s [Wed Jul 14 14:01:33 2010].161000 > msFreeMap(): freeing map at 019AB590. [Wed Jul 14 14:01:33 2010].505000 > CGI Request 1 on process 2064 > [Wed Jul 14 14:01:33 2010].677000 msOracleSpatialLayerGetItems(): Query > error. Cannot retrieve column list [Wed Jul 14 14:01:33 2010].677000 > msDrawMap(): Image handling error. Failed to draw layer named > 'provincias'. [Wed Jul 14 14:01:33 2010].677000 mapserv request processing > time (msLoadMap not incl.): 0.172s [Wed Jul 14 14:01:33 2010].677000 > msFreeMap(): freeing map at 019AB590. [Wed Jul 14 14:01:33 2010].989000 > CGI Request 1 on process 3216 > [Wed Jul 14 14:01:34 2010].130000 msOracleSpatialLayerGetItems(): Query > error. Cannot retrieve column list [Wed Jul 14 14:01:34 2010].130000 > msDrawMap(): Image handling error. Failed to draw layer named > 'provincias'. [Wed Jul 14 14:01:34 2010].130000 mapserv request processing > time (msLoadMap not incl.): 0.141s [Wed Jul 14 14:01:34 2010].130000 > msFreeMap(): freeing map at 019AB590. > > Do we have to refresh something or do somethign else? > > Layer config: > > CONNECTIONTYPE oraclespatial > CONNECTION "newuser/newp...@ora10gex" > > If configure the layer with the old user, it works. > > Thanks. > > Un saludo, > > ··········································································· > ······· > > David Alda Fernández de Lezea > Lurralde eta Biodibertsitate Saila / Dpto. de Territorio y Biodiversidad > > IKT > Granja Modelo s/n · 01192 · Arkaute (Araba) > > ··········································································· > ······· Tlfnos.: 945-00-32-95 Fax: 945-00.32.90 > ··········································································· > ······· email: [email protected] web: www.ikt.es > ·········································································· > ········ _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > -- Alan Boudreault Mapgears http://www.mapgears.com _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
