34.6 SDO_WCS.RevokePrivilegesFromWCS

Format

SDO_WCS.RevokePrivilegesFromWCS(
     table_name  IN VARCHAR2, 
     wcs_schema  IN VARCHAR2); 

Description

Revokes select and update privileges on the specified table in the invoking user’s schema from the specified wcs_schema user.

Parameters

table_name

The name of a GeoRaster table that previously was granted privileges using SDO_WCS.GrantPrivilegesToWCS procedure.

wcs_schema

Name of the WCS schema from which to revoke the privileges. Must not be the same as the user schema containing the GeoRaster objects.

Usage Notes

Do not use this procedure when the WCS schema is the same as the schema for the GeoRaster objects.

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

Examples

The following example revokes read and update privileges on GEORASTER_TABLE and all raster data tables associated with it from the WCS schema named WCS_1.

BEGIN
  SDO_WCS.RevokePrivilegesFromWCS('GEORASTER_TABLE','WCS_1'’);
END;
/