NIM007484 for No Product Found

Bug ID Number	NIM007484
Submitted	March 20, 2007
Last Modified	April 2, 2025
Applies to	No Product Found
Version found	9.2
Version Fixed	9.3
Status	Fixed

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.

Use ArcCatalog to revoke the privileges for the raster business table, F_table, and S_tables.
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;
```