BUG

Cannot use ArcCatalog to revoke all raster privileges

Last Published: April 25, 2020

Description


Note:
This software issue was fixed in version 9.3.

When using ArcCatalog to revoke raster dataset or raster catalog privileges granted to other users, only the privileges on the raster business tables (raster business table, F_table, and S_table) are revoked. Users still retain the privileges granted on SDE_AUX, SDE_BLK, SDE_BND, SDE_RAS, and SDE_VAT tables.

Use SQL to revoke the privileges on all the remaining tables.

Cause

This is a known issue in versions prior to 9.3.

Workaround

To revoke all raster privileges granted to a user on a raster in ArcSDE, use SQL in addition to ArcCatalog.

  1. Use ArcCatalog to revoke the privileges for the raster business table, F_table, and S_tables.
  2. Use SQL to revoke the privileges from the user for the SDE_AUX, SDE_BLK, SDE_BND, and SDE_RAS tables at the database level.

    For example, in Oracle:
    1. Login to SQLPlus.
    2. Enter the following command:

    data_owner@SQL>revoke select on SDE_AUX_1 from another_user;

Article ID:000009038

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic