新创建的rman用户，没有授权连接，也能用rman连接数据库,

cntoen

[oracle@node1 clear_archive]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on 星期四 6月 28 15:29:55 2012

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


连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> create user rman identified by rman;

用户已创建。

SQL> exit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options 断开
[oracle@node1 clear_archive]$ rman target rman/rman

恢复管理器: Release 10.2.0.5.0 - Production on 星期四 6月 28 15:30:21 2012

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

连接到目标数据库: ASM10G (DBID=88190031)

RMAN> list archivelog all;

使用目标数据库控制文件替代恢复目录

已存档的日志副本列表
关键字     Thrd Seq     S 时间下限            名称
------- ---- ------- - ------------------- ----
38731   1    13682   A 2012-06-27 09:00:33 +FLASH_RECOVERY_AREA/asm10g/archivelog/2012_06_28/thread_1_seq_13682.3428.787130357
38733   1    13682   A 2012-06-27 09:00:33 /home/oracle/archivelog/asm10g1/1_13682_751656975.dbf
38732   1    13682   A 2012-06-27 09:00:33 /home/oracle/archivelog/asm10g/1_13682_751656975.dbf
新创建的rman用户，没有授权连接，也能用rman,还能查看到归档日志，难道rman就没有权限问题限制了？

欢迎知道者拍

Maclean Liu(刘相兵

conn   rman/rman

select * from session_privs;
select * from session_roles;

cntoen

SQL> conn rman/rman
ERROR:
ORA-01045: 用户 RMAN 没有 CREATE SESSION 权限; 登录被拒绝

如果在sqlplus执行这样，报这样错误。

Maclean Liu(刘相兵

SQL> create user rman identified by rman;

用户已创建。

rman target rman/rman


SQL> select username,program from v$session where program like '%rman%';

USERNAME             PROGRAM
-------------------- --------------------
SYS                  rman.exe
SYS                  rman.exe


sqlnet.ora

#SQLNET.AUTHENTICATION_SERVICES = (NTS)

==》注释掉操作系统认证

C:\Users\Maclean.Liu>rman target rman/rman

恢复管理器: Release 11.2.0.1.0 - Production on 星期四 6月 28 15:47:08 2012

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

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: 内部恢复管理器程序包初始化失败
RMAN-04005: 目标数据库中存在错误:
ORA-01031: insufficient privileges