ORA-30742: cannot grant SELECT privilege WITH HIERARCHY OPTION on this object

ORA-30742: cannot grant SELECT privilege WITH HIERARCHY OPTION on this object
Cause: The user tried to grant SELECT privilege WITH HIERARCHY OPTION on an object that is not one of the following : object table of non final type, object view of non final type.
Action: Ensure that the SELECT privilege WITH HIERARCHY OPTION is granted on a valid object.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:49

ORA-30742：无法对此对象授予SELECT特权WITH HIERARCHY OPTION,
.原因：用户尝试对不是以下某个对象的对象授予WITH特权WITH HIERARCHY OPTION：非最终类型的对象表，非最终类型的对象视图。,
.操作：确保在有效对象上授予WITH HIERARCHY OPTION的SELECT特权。,
.

aiaiDBA

13718043309

010-86462881

ORA-30742: cannot grant SELECT privilege WITH HIERARCHY OPTION on this object

1 个回答

相似问题