RMAN Priviligies and Role to Create backups
Hi everyone,
I have some questions regarding RMAN backup options in my mind and want your help in their clarification.
1) We want to taken backup of Database with RMAN and for that we want to create a new Database user to take the backup rather than sys user. For this what prives this users need other than connect, quota etc. What we want to do is that we want to ensure that this RMAN user can only take backups and nothing else. I've read in the documentation that in order to take backup through RMAN ; the RMAN users must have sysdba role. Is this necessary? Don't you think this can compromise the db security?
Kindly note that currently we are using control file as RMAN repository so no need the discussion of Recovery catalog in our case.
Regards,
Kamran