文档解释
ORA-30740: cannot grant UNDER privilege on this object
Cause: The user tried to grant UNDER privilege on an object that is not one of the following : non final object type, object table of non final type, object view of non final type.
Action: Ensure that the UNDER privilege is granted on a valid object.
ORA-30740错误是由当使用GRANT语句时,当给予对象具有UNDER特权时出现的错误。
官方解释
Cause: A GRANT statement specified UNDER privilege to be granted on an object that does not support UNDER privilege.
Action: Specify UNDER privilege only on object types that support it.
常见案例
一般处理方法及步骤
1)检查尝试授予的UNDER特权的对象是否支持UNDER特权。
2)确保只在支持UNDER特权的对象上授予UNDER特权,可以使用以下该语句查询对象:
SELECT * FROM DBA_UNDER_INVOKING;
3)尝试更改授予`UNDER`特权的语句或者使用另外的对象类型。
4)在其他可能出现的ORA错误的情况下,最好尝试调查其他因素,如内存,表空间,版本等,然后相应地修复错误。