TraceLife

真正的幸福,在于对平淡生活的热爱……

导航

ORA-0131: Insufficient privileges.

Posted on 2009-08-25 14:58  hallo  阅读(4267)  评论(0编辑  收藏  举报

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    

image
    这里使用管理员登陆后,执行如下 SQL 语句。为对应的用户授予合适的权限。
GRANT DEBUG CONNECT SESSION TO username;

Note:
     Oracle 系统版本为 Oracle 10.2g