laptop and a wrench

Bogue

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'.

Dernière publication: August 25, 2014 ArcSDE/Enterprise Geodatabase
Numéro d’ID de bogue NIM063612
EnvoiDecember 15, 2010
Dernière modificationApril 2, 2025
S’applique àArcSDE/Enterprise Geodatabase
Version trouvée9.3.1
Version de correctionN/A
StatutFixed

Solution de contournement

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.

Étapes pour reproduire

ID de bogue: NIM063612

Logiciel:

  • ArcSDE/Enterprise Geodatabase

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Esri Community

Rechercher des informations associées

Training

Rechercher une formation sur ce sujet

ArcGIS Ideas

Explorer des pistes et donner un avis

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement