laptop and a wrench

Bug

The ArcGIS Desktop geoprocessing tool "Create Database User" grants an additional privilege (SELECT ON DBA_ROLES) to an Oracle user that a database-created Oracle user would not be granted if following the Esri documentation.

Last Published: February 26, 2015 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM090753
SubmittedApril 19, 2013
Last ModifiedSeptember 24, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found10.1
Program languageAll
Operating SystemWindows OS
Operating System Version2008
Version Fixed10.3
StatusFixed

Workaround

To alter privileges in Oracle, connect as sys or system user and REVOKE SELECT ON DBA_ROLES FROM USER or GRANT SELECT ON DBA_ROLES TO USER.

Steps to Reproduce

Bug ID: NIM090753

Software:

  • ArcSDE/Enterprise Geodatabase

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