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

snowdba發表於2015-04-27
在實驗環境下想要給使用者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

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


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部落格 ” ，連結：http://blog.itpub.net/29047826/viewspace-1606895/，如需轉載，請註明出處，否則將追究法律責任。

相關文章