听海★蓝心梦 发表于 2011-10-28 09:04
GRANT execute on dbms_stats to rnos3 试试
给了,也成功了。
SQL> GRANT execute on dbms_stats to rnos3 ;
Grant succeeded.
还是会报权限不足和不存在。
begin
dbms_stats.gather_index_stats('T_CELL','IDX_T_CELL');
end;
select * from user_sys_privs
SQL> select * from user_sys_privs;
USERNAME
PRIVILEGE
ADMIN_OPTION
------------------------------ ---------------------------------------- ------------
RNOS3
SELECT ANY TABLE
NO
RNOS3
SELECT ANY DICTIONARY
NO
RNOS3
UNLIMITED TABLESPACE
YES
RNOS3
CREATE ANY TABLE
NO
RNOS3
CREATE TABLE
NO