laptop and a wrench

Bug

Grant privileges to second user by owner on MV view to edit failed with error “ORA-01720: grant option does not exist for 'SDE.STATE_LINEAGES'.

Zuletzt veröffentlicht: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug-ID-Nummer NIM063612
EingereichtDecember 15, 2010
Zuletzt geändertApril 2, 2025
Gilt fürArcSDE/Enterprise Geodatabase
Gefunden in Version9.3.1
Behoben in VersionN/A
StatusFixed

Workaround

1. As SDE (or sys) user grant privileges to view owner with the “with grant option” through sql:SQL> grant select,insert,update,delete on state_lineages to msd with grant option; Grant succeeded. 2. As owner, Grant select, insert, update, delete on mv view to second user (maxweb) through sql (or sdetable):SQL> grant select,insert,update,delete on cities_view to maxweb; Grant succeeded. 3. As SDE (or sys) user REVOKE privileges from owner granted in step 1 through sql:SQL> revoke select,insert,update,delete on state_lineages from msd; Revoke succeeded.

Schritte zur Reproduzierung

Bug-ID: NIM063612

Software:

  • ArcSDE/Enterprise Geodatabase

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Esri Community

Nach zugehörigen Informationen suchen

Training

Nach Schulungen zu diesem Thema suchen

ArcGIS Ideas

Ideen erkunden und Feedback geben

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln