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博客 ” ,链接:https://blog.itpub.net/16566331/viewspace-675950/ ,如需转载,请注明出处,否则将追究法律责任。