PLS-00714: supertypes's AUTHID is DEFINER but supertype and subtype are not in same schema

PLS-00714: supertypes's AUTHID is DEFINER but supertype and subtype are not in same schema
Cause: The supertype's AUTHID is DEFINER, but the supertype and subtype are defined in different schemas. SQL statements executed in dynamically dispatched methods can potentially pick up different values from database tables in the two schemas.
Action: Create the subtype in the same schema as the supertype.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00714：supertypes的AUTHID是DEFINER，但是超类型和子类型不在同一模式中,
.原因：超类型的AUTHID是DEFINER，但是超类型和子类型是在不同的模式中定义的。在动态调度方法中执行的SQL语句可能会从两个模式中的数据库表中选择不同的值。,
.操作：在与超类型相同的模式中创建子类型。,
.

aiaiDBA

13718043309

010-86462881

PLS-00714: supertypes's AUTHID is DEFINER but supertype and subtype are not in same schema

1 个回答

相似问题