O'Reilly logo

SQL All-in-One For Dummies®, 2nd Edition by Allen G. Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Book IV

Data Security

9780470929964-pp0401.eps

Contents at a Glance

Chapter 1: Protecting Against Hardware Failure and External Threats

What Could Possibly Go Wrong?

Taking Advantage of RAID

Backing Up Your System

Coping with Internet Threats

Installing Layers of Protection

Chapter 2: Protecting Against User Errors and Conflicts

Reducing Data-Entry Errors

Coping with Errors in Database Design

Handling Programming Errors

Solving Concurrent-Operation Conflicts

Passing the ACID Test: Atomicity, Consistency, Isolation, and Durability

Operating with Transactions

Getting Familiar with Locking

Tuning Locks

Enforcing Serializability with Timestamps

Tuning the Recovery System

Chapter 3: Assigning Access Privileges

Working with the SQL Data Control Language

Identifying Authorized Users

Classifying Users

Granting Privileges

Revoking Privileges

Granting Roles

Revoking Roles

Chapter 4: Error Handling

Identifying Error Conditions

Getting to Know SQLSTATE

Handling Conditions

Dealing with Execution Exceptions: The WHENEVER Clause

Getting More Information: The Diagnostics Area

Examining an Example Constraint Violation

Adding Constraints to an Existing Table

Interpreting SQLSTATE Information

Handling Exceptions

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required