Home » RDBMS Server » Backup & Recovery » What permission need to give the the backup user with RMAN?
What permission need to give the the backup user with RMAN? [message #73508] Wed, 12 May 2004 11:50 Go to next message
Jadie
Messages: 64
Registered: January 2002
Member
I use RMAN in a separate host to back up the production database. Connection to target DB is:

RMAN> connect target backup01/PASSWORD@prodDB

What permission or roles should be given to the user backup01 in the production DB? I don't want to give the DBA or sysdba permission... Thanks.

 

Report message to a moderator

Re: What permission need to give the the backup user with RMAN? [message #73510 is a reply to message #73508] Wed, 12 May 2004 12:19 Go to previous message
croca
Messages: 50
Registered: January 2004
Member
You need to grant sysdba role. f not, you won't be able to use RMAN.

Best luck!
you can try RMV from www.otools.com.ar if you plan to do backup with RMAN.

Report message to a moderator

Previous Topic: Database recovery using RMAN
Next Topic: Oracle BackUp & Recovery
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 12 04:12:55 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.