34.3 SDO_WCS.GrantPrivilegesToWCS

Format

SDO_WCS.GrantPrivilegesToWCS(
     table_name  IN VARCHAR2, 
     wcs_schema  IN VARCHAR2, 
   updateable  IN VARCHAR2 DEFAULT 'FALSE'); 

Description

Grants select and update privileges on all GeoRaster objects and the raster data tables of the GeoRaster table to the WCS schema when the WCS schema is different from the user schema (that is, the schema with GeoRaster objects).

Parameters

table_name

Name of the table that contains GeoRaster objects that will be published as coverages.

wcs_schema

Name of the schema to be used as the WCS schema.

updateable

The string TRUE or FALSE (default) indicating if update privilege is to be granted.

Usage Notes

If the user schema (schema with GeoRaster objects published as coverages) and the WCS schema are the same, do not use this procedure.

For information about support for WCS, see Web Coverage Service (WCS) Support.

Examples

The following example grant read privileges on all GeoRaster objects and the raster data tables of a table named GEORASTER_TABLE in the current schema to a WCS schema named WCS_1.

BEGIN
  SDO_WCS.grantPrivilegesToWCS(‘GEORASTER_TABLE’,’WCS_1’);
END;
/