Jukka,
Basically, you need read access to the schema.table in question. The
spatial views are automatically available if a user has read access to the
table. So the minimum access is
GRANT SELECT on SCHEMA.TABLENAME to USERNAME;
ALL_SDO_GEOM_METADATA is a view that contains metadata
For write access, one needs INSERT and/or UPDATE on an existing table. For
a new table, a user needs CREATE TABLE and CREATE SEQUENCE access to a
Schema and some tablespace allocation for the schema, ALTER USER USERNAME
QUOTA SIZE on TABLESPACE Y, or GRANT UNLIMITED TABLESPACE to USERNAME.
Mike
Hi,
What about if GDAL and Oracle can't find common understandment about SRID? I
have seen that GDAL tries then to insert something into MDSYS.CS_SRS and with
our user rights that fails always. I have not studied that further because that
comes always from my error and adding -lco SRID helps
The MDSYS.CR_SRS table has been deprecated. Its now a view and there are
whole set of tables that are used for handling new spatial reference
systems. User defined SRIDs should all be above 100 now. Specific info
is at