flashback_transaction_query表时报无权限

最新推荐文章于 2023-08-22 22:07:42 发布

转载最新推荐文章于 2023-08-22 22:07:42 发布 · 262 阅读

文章标签：

#数据库

本文解决Oracle10g中普通用户查询flashback_transaction_query表时遇到的权限不足问题(ORA-01031)。通过授予用户grant selectanytransaction权限成功解决了这一问题。

oracle10g普通用户执行查询flashback_transaction_query表时报无权限：

ORA-01031: 权限不足
01031. 00000 - "insufficient privileges"
*Cause:    An attempt was made to change the current username or password
           without the appropriate privilege. This error also occurs if
           attempting to install a database without the necessary operating
           system privileges.
           When Trusted Oracle is configure in DBMS MAC, this error may occur
           if the user was granted the necessary privilege at a higher label
           than the current login.
*Action:   Ask the database administrator to perform. the operation or grant
           the required privileges.
           For Trusted Oracle users getting this error although granted the
           the appropriate privilege at a higher label, ask the database
           administrator to regrant the privilege at the appropriate label.

给该用户加上select any dictionary 权限也不行。

给用户加上grant select any transaction to user 权限即可

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16566331/viewspace-675950/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16566331/viewspace-675950/