Home » RDBMS Server » Backup & Recovery » privileges in using RMAN
privileges in using RMAN [message #330029] Fri, 27 June 2008 06:41 Go to next message
sarwagya
Messages: 87
Registered: February 2008
Location: Republic of Nepal
Member
Hi,

I am trying to use RMAN to do backup & recovery in my system
through PHP.
So, first thing that I wanted to know is about the privileges required to connect
and do the rest of the processes.
I read somewhere that it needs the SYSDBA privilege to connect to the target
database through RMAN. Is it right?

Is there any other privilege that can be granted to a user to do this?
Actually, if possible, I wanted to provide only a limited privilege just sufficient to do the task.


Thanks.
Re: privileges in using RMAN [message #330032 is a reply to message #330029] Fri, 27 June 2008 07:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SYSDBA is the only privilege needed and requested.
Also an account and necessary privilege to connect to rman catalog if you use it.

Regards
Michel
Re: privileges in using RMAN [message #330036 is a reply to message #330032] Fri, 27 June 2008 07:23 Go to previous messageGo to next message
sarwagya
Messages: 87
Registered: February 2008
Location: Republic of Nepal
Member
Won't it be too risky to give the SYSDBA privilege to a web user?

I was wondering if there be any single permission(privilege) in the SYSDBA role which could just be granted.

[Updated on: Fri, 27 June 2008 07:23]

Report message to a moderator

Re: privileges in using RMAN [message #330050 is a reply to message #330036] Fri, 27 June 2008 07:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SYSDBA is a whole, it is a single privilege.
Don't give it to an anonymous user.

Regards
Michel
Re: privileges in using RMAN [message #330070 is a reply to message #330029] Fri, 27 June 2008 09:01 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you want the ability to limit backup & restore privileges, you may want to consider Oracle Secure Backup.
Re: privileges in using RMAN [message #331324 is a reply to message #330070] Thu, 03 July 2008 00:34 Go to previous messageGo to next message
sarwagya
Messages: 87
Registered: February 2008
Location: Republic of Nepal
Member
@ebrian,

As per your advice, I went through few pages related to Oracle Secure Backup(OSB).

Everywhere, the word tape backup is mentioned. Does OSB allow us to backup only in tape media?

Also,I couldn't find how it addresses my problem of limited privileges.

Please shed light over my questions.

Thanks.
Re: privileges in using RMAN [message #331539 is a reply to message #331324] Thu, 03 July 2008 19:39 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The granularity of access rights for OSB is discussed in Oracle Secure Backup Classes and Rights.

OSB allows backup to disk via a Virtual Tape Library (VTL). There are several versions of VTL's that are open source and available for free.
Previous Topic: RMAN backup failed
Next Topic: ORA-01595: error freeing extent (2) of rollback segment (6))
Goto Forum:
  


Current Time: Tue Dec 06 00:26:36 CST 2016

Total time taken to generate the page: 0.06018 seconds