SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

HP NonStop SQL/MX Installation and Management Guide—523723-004
5-1
5
Planning Database Security and
Recovery
Database security and recovery are essential topics to consider before creating an
SQL/MX database. Planning for security is the primary protection against unauthorized
user intervention. Security, however, cannot eliminate errors by authorized users.
Planning for recovery is essential for protecting your database. Your recovery plan
should include protection against disk failures, software failures, application errors,
other equipment failures, catastrophic disasters, and human errors of all types.
This section addresses these topics:
•
Planning Database Security on page 5-1
•
Planning Database Recovery on page 5-6
•
Using TMF for Transaction Recovery, Database Consistency, and Database
Recovery on page 5-10
•
Using RDF to Set Up a Backup System on page 5-21
•
Using Backup and Restore 2 for Database Recovery on page 5-27
This section applies specifically to SQL/MX databases. For information about planning
security and recovery for an SQL/MP database, see the SQL/MP Installation and
Management Guide.
For information about performing recovery operations on an SQL/MX database, see
Section 12, Performing Recovery Operations.
Planning Database Security
Planning for database security is the primary protection against unauthorized user
intervention. When planning your SQL/MX database security, consider:
•
What are the requirements for security on the system or network?
•
How many different users access the same database?
•
How schemas should be defined so that the correct people have the authorization
to change and remove objects from the metadata?
•
What are the needs or restrictions of all users of your system, or a network of
systems?
For related information, see:
•
Authorization Requirements for Adding Database Objects on page 9-3
•
Authorization Requirements for Altering Database Objects on page 9-19
•
Authorization Requirements for Dropping Database Objects on page 9-28