The sysbackup privilege – how, when, and why should you use it?
It is recommended that you use the sysbackup
administrative privilege instead of the sysdba
administrative privilege to perform operations related to backup and recovery tasks.
Getting ready
For this recipe, you'll need:
- An existing database user (for example,
tom
) and a password file in 12c format, if you want to complete it using a password-authenticated user - An existing OS user (for example,
john
), who belongs to thebackupdba
OS group, in order to connect to the database using OS authentication
How to do it...
Instructions are given in the Database authentication and OS authentication sections.
Database authentication
The instructions for database authentication are as follows:
- Connect ...
Get Oracle Database 12c Security Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.