在實驗環境下想要給使用者HR賦予dba許可權，結果執行grant命令時出現ORA-01031: insufficient privileges

解決問題很簡單，重新建立一次密碼檔案。下面是處理過程留作備忘。

SYS@snow > alter user hr identified by hr;

alter user hr identified by hr

*

ERROR at line 1:

ORA-01031: insufficient privileges

SYS@snow > exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options

[oracle@snowlab ~]$

[oracle@snowlab ~]$ cd $ORACLE_HOME/dbs

[oracle@snowlab dbs]$ ll

total 48

-rw-rw---- 1 oracle oinstall 1544 Apr 24 14:46 hc_snow.dat

-rw-r--r-- 1 oracle oinstall 12920 May 3 2001 initdw.ora

-rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora

-rw-rw---- 1 oracle oinstall 24 Apr 24 10:54 lkSNOW

-rw-r----- 1 oracle oinstall 1536 Apr 24 14:03 orapwsnow

-rw-r----- 1 oracle oinstall 1536 Apr 24 13:32 orapwsnow.1429896722954

-rw-r----- 1 oracle oinstall 3584 Apr 24 14:46 spfilesnow.ora

重新建立一次密碼檔案

[oracle@snowlab dbs]$ orapwd file=orapwdsnow password=oracle entries=30 force=y

[oracle@snowlab dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 24 14:51:08 2015

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options

再次執行授權成功

SYS@snow > grant dba to hr;

Grant succeeded.

SYS@snow >

sys使用者執行 grant授權提示ORA-01031: insufficient privileges

相關文章