laptop and a wrench

Bug

The ArcGIS Pro privileges are not applied to feature classes in non-Esri database sequences, and returns the error message, "ERROR permission denied for sequence objectid_seq SQLSTATE=42501".

Last Published: July 8, 2022 ArcGIS Pro
Bug ID Number BUG-000150110
SubmittedJune 20, 2022
Last ModifiedNovember 8, 2022
Applies toArcGIS Pro
Version found2.9.3
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusIn Review

Workaround

Running SQL such as 'GRANT ALL ON SEQUENCE nosde1.objectid_seq TO nosde2;' in the database resolves the issue.

Steps to Reproduce

Bug ID: BUG-000150110

Software:

  • ArcGIS Pro

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