[Gvsig_english] Re: Gvsig_internacional Digest, Vol 23, Issue 16

[Ing. Andrea Peri]

Hi,

there is a mis-understanding.

you can do the same think with the USER_SDO_GEOM_METADATA.

you can do:

insert into user_sdo_geom_metadata
values(
   'TEMP_TABLE',
   'GEOM_FIELD',
   mdsys.sdo_dim_array(
     mdsys.sdo_dim_element('X',1540000,1780000,0.005),
     mdsys.sdo_dim_element('Y',4670000,4930000,0.005)
     ),
   82087
);

and you can do:

select * from user_sdo_geom_metadata where table_name='TEMP_TABLE';
or
delete user_sdo_geom_metadata where table_name='TEMP_TABLE';

exactly as you want to do with ALL_SDO_GEOM_METADATA.

The only difference is that to write on ALL_SDO_GEOM...
your account need superior right (like DBA for example)

an account with the roles connect and resource 
(for example) can write on the USER_SDO_GEOM
(is sufficient the right to create a table, more simple and acceptable).

the ALL_SDO_GEOM is usable only from DBA for some 
expecially situation like (for example) when you 
need to create a table with sdo_geom fields on another schema
different from your (infact it has the OWNER field).
But need a dba right to write on ALL_SDO.. .

You can verify this creating an account and giving to it
only the roles
"connect" and "resource".

this account can write and read from 
USER_SDO_GEOM but cannot write on ALL_SDO_GEOM.


Best Regards,
Andrea.


 >Hello,
 >
 >- the ojdbc14.jar must ONLY be copied to: extensiones/com.iver.cit.gvsig/lib
 >
 >- we are using ALL_... for both reading and 
inserting, so I guess we should use ALL... when 
reading tables and USER... >when writing tables, is it ok like that?
 >
 >- thanks for the info about EPSG.
 >
 >Regards
 >,
 >Juan Lucas Domínguez Rubio
 >Prodevelop SL, Valencia (España)
 >Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
 ><http://www.prodevelop.es>http://www.prodevelop.es 
<http://www.prodevelop.es/>





===================================================
Andrea Peri
Regione Toscana
Direzione Generale POLITICHE TERRITORIALI E AMBIENTALI
Settore SERVIZIO GEOGRAFICO REGIONALE
Via di Novoli, 26 - 50127 Firenze
Tel. +0039 055 438.3968
===================================================