laptop and a wrench

漏洞

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

上次发布: August 25, 2014 ArcSDE/Enterprise Geodatabase
漏洞 ID 编号 NIM063612
已提交December 15, 2010
上次修改时间April 2, 2025
适用范围ArcSDE/Enterprise Geodatabase
找到的版本9.3.1
修正版本N/A
状态Fixed

解决办法

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.

重现步骤

漏洞 ID: NIM063612

软件:

  • ArcSDE/Enterprise Geodatabase

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项