SDO_UTIL.REVOKE_VECTORTILE_CACHE

Format

SDO_UTIL.REVOKE_VECTORTILE_CACHE(
  schema_name     IN VARCHAR2
);

Description

Revokes privileges on vector tile caches for the specified schema.

Parameters

schema_name

Name of the schema whose privileges on a vector tile cache is revoked.

Usage Notes

You can revoke a vector tile cache access for a schema by calling SDO_UTIL.REVOKE_VECTORTILE_CACHE. Note that if the schema user attempts to call SDO_UTIL.GET_VECTORTILE after the cache access privilege is revoked, a vector tile is still returned. However, this vector tile is a computed one and not from the cache. Only when the owning schema user revokes access on the source table (that contains the source data to build the vector tiles) as well, then a call to SDO_UTIL.GET_VECTORTILE does not return a tile.

Examples

The following example calls SDO_UTIL.REVOKE_VECTORTILE_CACHE to revoke user_b privileges on the vector tile cache owned by user_a.

-- user_a revokes user_b access to the cache
SDO_UTL.REVOKE_VECTORTILE_CACHE('user_b');

Although cache access is revoked, if user_b attempts to call SDO_UTIL.GET_VECTORTILE, then the vector tile is computed and returned.

–- user_b attempts to access the cache
SELECT SDO_UTIL.GET_VECTORTILE(TABLE_NAME=>'USER_A.COUNTIES',
                                   GEOM_COL_NAME=>'GEOM',
                                   TILE_ZOOM=>8, TILE_X=>73, TILE_Y=>97,
                                   ATT_COL_NAMES=>sdo_string_array('COUNTY','LANDSQMI'))
FROM dual;

In case user_a revokes access to the counties table (REVOKE READ ON counties FROM user_b;) as well, then no tile is returned when user_b attempts to run the preceding code. Only an error message stating that USER_A.COUNTIES does not exist is displayed.