laptop and a wrench

Bug

When owner Grants object level privilege to a feature class (select, update, delete, insert) to a grantee, and then revokes all privileges, select privileges do not get revoked for A and D Tables of the feature classes.

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM008494
SubmittedMay 2, 2007
Last ModifiedApril 28, 2025
Applies toNo Product Found
Version found9.2
Version Fixed9.4
StatusFixed

Description

When revoking privileges on a versioned feature class, the select privileges are not revoked from the versioned table's adds and deletes tables.

Even though the privileges are not revoked from the adds and deletes tables, users will not be able to select or edit the versioned table with ArcGIS. However, the users will continue to have access to the tables directly with SQL. This may be considered a security risk.

Cause

The cause of the problem resides in the ArcSDE function, which revokes privileges from objects. The adds and deletes tables are mistakenly skipped when privileges are revoked.

Workaround

Explicitly revoke privileges on the versioned classes adds and deletes table using SQL or the DBMS's administration utilities.

For example, in Oracle, to revoke the privileges on a versioned tables adds and deletes table, one must first identify the table's registration_id and then revoke the privilege.

  1. Identify the versioned table's registration_id value in SQL*Plus. In the following example, the versioned table is named gas_mains.

    Code:
    SQL> SELECT registration_id FROM sde.table_registry WHERE table_name = 'GAS_MAINS';

    REGISTRATION_ID
    ---------------
                 45

  2. Explicitly revoke the SELECT privilege from the adds and deletes tables for the given user.

    Code:
    SQL> REVOKE SELECT ON a45 FROM brent;

    Revoke succeeded.

    SQL> REVOKE SELECT ON d45 FROM brent;

    Revoke succeeded.

Steps to Reproduce

Bug ID: NIM008494

Software:

  • No Product Found

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options