Fwd: DBA权限但执行SP时报ORA-01031 insufficient privileges 错误，授权SQL

From: Zhou Xiangzhen
Date: 2010/5/6
Subject: DBA权限但执行SP时报ORA-01031 insufficient privileges 错误，授权SQL
To: "Ying.Wang" <wying45@gmail.com>

Connected to Oracle9i Enterprise Edition Release 9.2.0.5.0 

Connected as sada

SQL> grant create table,select any table to sada;

Grant succeeded

SQL> grant update any table to sada;

Grant succeeded

SQL> grant insert any table to sada;

Grant succeeded

Thanks
Xiangzhen