OraFAQ Forum: Backup & Recovery » privileges in using RMAN

Home » RDBMS Server » Backup & Recovery » privileges in using RMAN

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

privileges in using RMAN [message #330029]

Fri, 27 June 2008 06:41

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.

Report message to a moderator

Re: privileges in using RMAN [message #330032 is a reply to message #330029]

Fri, 27 June 2008 07:03

Michel Cadot
Messages: 68647
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

Report message to a moderator

Re: privileges in using RMAN [message #330036 is a reply to message #330032]

Fri, 27 June 2008 07:23

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

Michel Cadot
Messages: 68647
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

Report message to a moderator

Re: privileges in using RMAN [message #330070 is a reply to message #330029]

Fri, 27 June 2008 09:01

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.

Report message to a moderator

Re: privileges in using RMAN [message #331324 is a reply to message #330070]

Thu, 03 July 2008 00:34

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.

Report message to a moderator

Re: privileges in using RMAN [message #331539 is a reply to message #331324]

Thu, 03 July 2008 19:39

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.

Report message to a moderator

Previous Topic:	RMAN backup failed
Next Topic:	ORA-01595: error freeing extent (2) of rollback segment (6))

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 04:53:31 CDT 2024