RMAN: SYSBACKUP Role
Oracle has released several roles specifically for administers to perform specific actions. With the release of Oracle 12c, there is a new role specifically for managing recovery operations. the SYSBACKUP role allows named credentials to be used to restore partitions, tables views and so on, without necessarily needing to connect to with the SYSDBA privilege.Simply grant the role to the user, like you normally would and then that user can connect with named credentials.
The SYSBACKUP role includes the following privileges by default:
- Select any transaction
- Unlimited tablespace
- Resumable
- Create any cluster
- Drop tablespace
- Alter session
- Audit any
- Create any table
- Create any dictionary
- Alter system
- Alter database
- Select any dictionary
- Alter tablespace
- SELECT_CATALOG_ROLE
NOTE: no object grants are included in this privilege. Backup Operator does not necessarily need access to the data, only to recover data a specific points in time.
Comments
Post a Comment