SQL执行报错

sunjt888@qq.com

Procedure里执行大概这样一段SQL，Insert Into T1 SELECT * FROM T1_COPY，报ORA-28081: 权限不足 - 命令引用了已经过编写的对象。但我把这段SQL单独拷贝出来，执行时没有问题，哪位帮忙给解释一下？

foxhuntwang

要给用户赋显示权限。给用户 赋权 INSERT 权限

Maclean Liu(刘相兵

[oracle@mlab2 ~]$ oerr ora 28081
28081, 00000, "Insufficient privileges - the command references a redacted object."
// *Cause: The command referenced a redacted column in an
// object protected by a data redaction policy.
// *Action: If possible, modify the command to avoid referencing any
// redacted columns.  Otherwise, drop the data redaction policies that
// protect the referenced tables and views, or ensure that the user issuing
// the command has the EXEMPT REDACTION POLICY system privilege, then
// retry the operation.  The EXEMPT REDACTION POLICY system privilege
// is required for creating or refreshing a materialized view when the
// materialized view is based on an object protected by a data redaction
// policy.  The EXEMPT REDACTION POLICY system privilege is required for
// performing a data pump schema-level export including any object
// protected by a data redaction policy.  All data redaction policies are
// listed in the REDACTION_COLUMNS catalog view.

Maclean Liu(刘相兵

做一个errorstack  并触发该错误

alter system set events ' 28081 trace name context forever level 3';


运行你触发问题的语句


压缩打包上传日志