Using the
target database??™s control file for RMAN is easy, but it??™s not the best solution for a robust enterprise
backup methodology. Although a recovery catalog requires another database to store the metadata
for the target database along with a record of all backups, it is well worth it when all the control
files in the target database are lost due to a catastrophic failure. In addition, a recovery catalog
retains historical backup information that may be overwritten in the target database??™s control file
if the value of CONTROL_FILE_RECORD_KEEP_TIME is set too low.
RMAN is discussed in detail in Chapter 12.
Security Capabilities
In the next few sections, I??™ll give a brief overview of the different ways that the Oracle 11g
Database controls and enforces security in a database. Account security based on user and
schema objects was covered in the section on database objects; the other security topics are
covered here.
An in-depth look at these and other security capabilities within Oracle is covered in Chapter 9.
Privileges and Roles
In an Oracle database, privileges control access to both the actions a user can perform and the
objects in the database. Privileges that control access to actions in the database are called system
privileges, whereas privileges that control access to data and other objects are called object
privileges.
To make assignment and management of privileges easier for the DBA, a database role groups
privileges together.
Pages:
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123