Opened 15 years ago
Closed 15 years ago
#3098 closed enhancement (fixed)
georaster - cross schema data access
Reported by: | ilucena | Owned by: | ilucena |
---|---|---|---|
Priority: | normal | Milestone: | 1.7.0 |
Component: | default | Version: | svn-trunk |
Severity: | normal | Keywords: | georaster |
Cc: |
Description
As a user pointed out, the GeoRaster identification string only allow access to a user's own data. But sometime a DBA grants permission to one user to at least read data from others. In that case a simple solution would be entering the schema name into the table_name field separated by a period "." , ex:
$ gdalinfo georaster:scott/tiger@orcl,spock.planets,globe,id=102
In that case, user scott could read the data from user spock's schema.
Change History (3)
comment:1 by , 15 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
comment:2 by , 15 years ago
Cc: | removed |
---|---|
Resolution: | fixed |
Status: | closed → reopened |
comment:3 by , 15 years ago
Resolution: | → fixed |
---|---|
Status: | reopened → closed |
Committed revision 17533.
Examples of use:
Create table in a single schema (scott) and insert a new GeoRaster:
gdal_translate -of georaster 10.tif geor:scott/tiger@orcl,cities,view \ -co DESCRIPTION="(ID NUMBER, VIEW SDO_GEORASTER)" \ -co INSERT="(1,SDO_GEOR.INIT('cities_rdt',1))"
Grant permission to another user:
SQL> grant select,insert,update,delete on cities to spock; SQL> grant select,insert,update,delete on cities_rdt to spock;
Insert a second GeoRaster in a single schema:
gdal_translate -of georaster 20.tif geor:scott/tiger@orcl,cities,view \ -co INSERT="(2,SDO_GEOR.INIT('cities_rdt',2))"
Insert a third GeoRaster as another user:
gdal_translate -of georaster 30.tif geor:spock/lion@orcl,scott.cities,scene \ -co INSERT="(3,SDO_GEOR.INIT('cities_rdt',3))"
Update one GeoRaster as another user:
gdal_translate -of georaster 101.tif geor:spock/lion@orcl,scott.cities,scene,id=1
Update one GeoRaster as another user using RDT/RID as identification:
gdal_translate -of georaster 102.tif geor:spock/lion@orcl,cities_rdt,2
I will update the documentation shortly.
Implemented on r17526
Details:
Examples:
List all the GeoRaster tables from schema "spock":
List all the GeoRaster rows on table planets column scene from schema "spock":
Convert the GeoRaster identified by Raster Data Table PLANETS_RDT and RasterId = 37 to a Geotiff file
Convert the GeoRaster identified a where clause:
TODO: Add it to the documentation