ORA-01720问题解决

1.发生场景

表A在用户u1下建立，u2下建立同义词A，u2下建立查询A的视图v，u3下建立同义词v,u3下查询v时出现“表或视图不存在”，进行grant后u3查询出现ORA-01031: insufficient privileges错误。

返回u2下grant select on v to u3,报出异常

ORA-01720: grant option does not exist for 'string.string'

Cause: A grant was being performed on a view and the grant option was not present for an underlying object.

Action: Obtain the grant option on all underlying objects of the view.

2.解决方法

在u1对于表A进行权限更正，采用 grant select (ALL) on A to u2 with grant option;问题被解决，主要原因应该与grant权限赋予时权限的传递有关。