设为首页 加入收藏

TOP

sys用户,密码文件dba权限的关系
2014-11-23 23:25:17 来源: 作者: 【 】 浏览:5
Tags:sys 用户 密码 文件 dba 权限 关系

oracle@ywdb ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Apr 29 15:40:38 2014

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> 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 disabled

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
You 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 2014

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> grant sysdba to system;

Grant succeeded.

SQL>

system用户没有dba权限的。

但是想授予他权限的话,

那么必须添加一个密码文件。

然后才能授予。

】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇再谈通过http访问SSAS 下一篇查找本库包含某字段的所有表

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: