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, 2014ArcSDE/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.