在实验环境下想要给用户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 >

ITPub博客

sys用户执行 grant授权提示ORA-01031: insufficient privileges