Oracle SQL for secure relational databases

Description

Contents Preface Chapter 1 Good Database Design 1.1. Introduction 1.1.1. Database Design 1.1.2. The First Normal Form (1NF) 1.1.2.1. Repeating Groups 1.1.2.2. Composite Data Items 1.1.3. Keys 1.1.4. Functional Dependency 1.1.4.1. Finding a PRIMARY KEY Using Functional Dependency 1.1.4.2. In Which Table Do We Put Salary? 1.1.4.3. A Closer Look at Functional Dependency and Normal Forms 1.1.4.3.1. More FD Manipulations 1.1.4.3.2. Add an Address 1.1.4.4. Concatenated Keys and Intersection Data 1.1.5. The Third Normal Form, 3NF 1.1.6. The Equi-join References Chapter 2 Database Integrity 2.1. Introduction – What Is Integrity? 2.1.1. The CREATE TABLE Command 2.1.1.1. Defining the PRIMARY KEY CONSTRAINT 2.1.1.2. Disallowing null Values – A CHECK CONSTRAINT 2.1.1.3. CHECK Constraints on Domains 2.1.1.4. CHECK CONSTRAINTs on More Than One Attribute 2.1.1.5. The UNIQUE CONSTRAINT 2.1.1.6. A Referential Integrity CONSTRAINT 2.1.2. Actions on CONSTRAINTS References Chapter 3 The Database 3.1. Introduction 3.1.1. What Is a Privilege? 3.1.2. Users, Responsibilities and Security 3.1.3. Users and Privileges 3.1.4. GRANTing Privileges 3.4.1. WITH ADMIN OPTION 3.1.5. Defining a Tablespace and Getting Started with the Database 3.5.1. The DBA Is Created by the System Administrator 3.5.2. Level 2 Users Are Created by the DBA 3.1.6. Using Scripts 3.1.7. Setting the Environment with a Sign-on Script References Chapter 4 Privileges and ROLEs 4.1. Introduction 4.1.1. Start with a Clean Slate 4.1.2. Create Level 2 Users 4.1.3. Create a ROLE for Level 2 Users 4.3.1. Empower Level 2 Users 4.1.4. Level 2 CREATE TABLES 4.1.5. Level 3 Users Created 4.1.6. CREATE SYNONYM 4.1.7. GRANTing to PUBLIC Chapter 5 The Dictionary 5.1. The Dictionary Paradigm 5.2. Drilling Down into Information in the Dictionary Chapter 6 Accessing Other Users’ Tables with Scripts 6.1. Backups 6.2. Auditing 6.3. Granting DML Privileges to Level 3 Users 6.4. Using GRANT ALL Chapter 7 Expanding the Database 7.1. Getting Started with Linking Tables 7.2. Integrity Constraints 7.3. Some Beginning Queries 7.4. Auditing Queries and Backups – Version 2 7.4.1. Auditing 7.4.2. Backup References Chapter 8 Triggers to Enforce Auditing 8.1. What Is a Trigger? 8.2. An Embellished Trigger for Hardware_City 8.2.1. Testing the Trigger 8.3. Before Triggers vs. CONSTRAINTs 8.4. Trigger Caveats References Chapter 9 Multiple Users and Transactions 9.1. Serialized Transactions 9.2. COMMIT and ROLLBACK 9.3. More on COMMIT and ROLLBACK 9.4. SAVEPOINTs and ROLLBACK TO References Chapter 10 Concurrency 10.1. Consistency, Concurrency, and ACID Properties 10.2. Transactions Revisited 10.3. LOCKing 10.4. Deadlocks and Starvation References Other Websites Related To Multi-User Topics from Which the Reader May Dig Deeper Into Various Subjects About the Authors Index Blank Page