查看文章 |
Solution The Error ORA-28133
2009-10-10 14:52
Applies to : Oracle 9i Symptoms: 创建物化视图报此错误。 Cause: $ oerr ora 28133 28133, 00000, "full table access is restricted by fine-grained security" // *Cause: The user is not SYS and doesn't have full table access due to VPD // or FGA policies. This only happens for internal DML/query // under a DDL // *Action: Grant appropriate privilege, or report to Oracle if you feel this // is too restrictive 如上分析,可能权限不够,切换用户,使用sys用户执行,任然报错。 Solution: 1,经查相关文档,数据库在开fga审计时,会触发此Bug,升级到10.1,问题可解决。现在系统是没有计划升级的。 2,临时禁用fga审计功能,再执行此物化视图,问题解决。 |
最近读者: