重庆思庄Oracle、Redhat认证学习论坛

标题: oracle 采用操作系统认证登陆数据库 [打印本页]

作者: michaeljet 时间: 2015-11-23 22:46
标题: oracle 采用操作系统认证登陆数据库
以oracle用户登陆操作系统，用sys用户任意密码登陆。
[oracle@dbsrv ~]$ sqlplus sys/akdosfw as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Nov 24 06:39:31 2015

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

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

SQL> connect sys/dksfwj as sysdba
Connected.
SQL>
SQL>
SQL> show user
USER is "SYS"

[oracle@dbsrv ~]$ rman target sys/testdkslfdsfkd

Recovery Manager: Release 11.2.0.4.0 - Production on Tue Nov 24 06:42:00 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SZTECH (DBID=3189320464)

RMAN> exit

Recovery Manager complete.
[oracle@dbsrv ~]$ rman target sys/testdksadsfe

Recovery Manager: Release 11.2.0.4.0 - Production on Tue Nov 24 06:42:08 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SZTECH (DBID=3189320464)

RMAN>

由此可见，当登陆数据时采用操作系统认证时，对输入的用户名和密码并没有进行检查。

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)