首页 > 代码库 > sys用户,密码文件 dba权限的关系
sys用户,密码文件 dba权限的关系
oracle@ywdb ~]$ sqlplus "/as sysdba"SQL*Plus: Release 11.1.0.7.0 - Production on Tue Apr 29 15:40:38 2014Copyright (c) 1982, 2008, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> alter user sys identified by oracle 2 ;User altered.SQL> alter user sys identified by oracle;User altered.SQL> alter user sys identified by manager;User altered.SQL> grant sysdba to system;grant sysdba to system*ERROR at line 1:ORA-01994: GRANT failed: password file missing or disabledSQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsYou have new mail in /var/spool/mail/oracle[oracle@ywdb ~]$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=‘manager‘ entries=10[oracle@ywdb ~]$ sqlplus "/as sysdba"SQL*Plus: Release 11.1.0.7.0 - Production on Tue Apr 29 15:49:03 2014Copyright (c) 1982, 2008, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> grant sysdba to system;Grant succeeded.SQL>
system用户没有dba权限的。
但是想授予他权限的话,
那么必须添加一个密码文件。
然后才能授予。
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。