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

[Juan Lucas Dominguez Rubio]

Hi, Andrea,
 
I mean that we can read the view ALL... to find out which tables are available, not only from the user's schema, so the user will be able to add to his view tables from other schemas, and we will write to USER... when the user stores a vector layer as an Oracle table.
 
When you use the "GeoDB" wizard to add a layer, the list of available tables you see is the content of ALL... (I understand that you can see that list.)
 
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/> 

________________________________

De: gvsig_internacional-bounces at runas.cap.gva.es en nombre de Ing. Andrea Peri
Enviado el: vie 21/12/2007 16:34
Para: gvsig_internacional at runas.cap.gva.es
Asunto: [Gvsig_english] Re: Gvsig_internacional Digest, Vol 23, Issue 16



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 <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
===================================================

_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at runas.cap.gva.es
http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 6810 bytes
Desc: not available
Url : http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20071222/f2a9143f/attachment.bin