Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sysbackup privilege how it works

Ras19811Mar 8 2017 — edited Mar 9 2017

Granted permission to oracle user scott..

grant sysbackup to scott;

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM     CON_ID

------------------------------ ----- ----- ----- ----- ----- ----- ----------

SYS                            TRUE  TRUE  FALSE FALSE FALSE FALSE          0

SCOTT                       TRUE  TRUE  FALSE TRUE  FALSE FALSE          0

sql>connect scott/tiger@orcl as sysbackup

Connected.

$>rman target scott/tiger@orcl as sysbackup

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Mar 8 15:19:25 2017

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

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: initialization of internal recovery manager package failed

RMAN-04005: error from target database:

ORA-01017: invalid username/password; logon denied

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2017
Added on Mar 8 2017
10 comments
2,447 views