ORA-01926 error message in ArcGIS Pro, not in ArcMap

761
2
Jump to solution
06-10-2020 06:08 AM
Robert_CraigAshby1
New Contributor III

I am getting this error when attempting to assign Priveleges to a Role in ArcGIS Pro with the Data Creator/ Schema Owner, however it's working just fine in ArcMap for our enterprise database.  The SELECT ON DBA_ROLES option has been turned on for the Data Creator by the Database Admin.  Any ideas on the underlying issue?

The only solution I am seeing in ESRI article (https://pro.arcgis.com/en/pro-app/help/data/geodatabases/manage-oracle/privileges-oracle.htm) and google searching is turn on SELECT on DBA_ROLES which has been done.

Thanks.

1 Solution

Accepted Solutions
Robert_LeClair
Esri Frequent Contributor

This is a known bug - BUG-000115301 - "Assigning privileges to a role in ArcGIS Pro's Catalog fails, throwing the Error:  "ORA-01926:  cannot GRANT to a role WITH GRANT Option for Oracle Enterprise Geodatabases."  It's in the Product Plan to be resolved - don't know when though.

Until the BUG is fixed, the current workaround is to grant privileges on a feature class/feature dataset to a role using ArcMap.

View solution in original post

2 Replies
Robert_LeClair
Esri Frequent Contributor

This is a known bug - BUG-000115301 - "Assigning privileges to a role in ArcGIS Pro's Catalog fails, throwing the Error:  "ORA-01926:  cannot GRANT to a role WITH GRANT Option for Oracle Enterprise Geodatabases."  It's in the Product Plan to be resolved - don't know when though.

Until the BUG is fixed, the current workaround is to grant privileges on a feature class/feature dataset to a role using ArcMap.

AndrewGilbert
New Contributor III

This is supposedly fixed in ArcGIS Pro 2.6.0 (search for "BUG-000115301" the release notes page).