ORA-0131:
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 appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label.
Scenario One
用 PL/SQL Developer 进行调试时,系统提示权限不足。Oracle 系统版本为 Oracle 10.2g
这里使用管理员登陆后,执行如下 SQL 语句。为对应的用户授予合适的权限。Note:
Oracle 系统版本为 Oracle 10.2g