laptop and a wrench

Bug

When using ArcSDE for Oracle, unable to register a table as versioned when privileges have been granted to a domain username ("domain/username").

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM040525
SubmittedDecember 5, 2008
Last ModifiedJune 5, 2024
Applies toNo Product Found
Version found9.3
Version Fixed9.4
StatusFixed

Description

Attempting to register a table as versioned when SELECT has been granted to a user with a domain name, "domain\username", fails with an underlying DBMS error ORA-00911: invalid character.

Cause

When an object class or feature class is registered as versioned, the privileges that have been granted on the class are then applied to the delta tables that are created for the class to support versioning.

The command fails when attempting to assign the privileges to users who have domain names, "domain\username".

Workaround

Do not attempt to grant privileges explicitly to Oracle users who have domain name prefixes, "domain\username".

Create a database role in the Oracle database, grant the privileges to the role by way of the privileges command in ArcCatalog, and then assign the role to the user by way of SQL.

If a "domain\username" has already been granted privileges on the object class prior to being registered as versioned, revoke the privilege and then proceed with registering the class as versioned.

    Steps to Reproduce

    Bug ID: NIM040525

    Software:

    • No Product Found

    Get notified when the status of a bug changes

    Download the Esri Support App

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options