Oracle SQL for secure relational databases

Type Book

Rate 0.0 /5

"A typical Oracle database has multiple users working simultaneously. Data is shared amongst the users, and this of course leads to security concerns. This book comes in from the angle of developing and maintaining a secure Oracle database with multiple users. The book shows how data can be shared in an orderly fashion and what a good secure database is. In this book, we assume that you are acquainted with basic Oracle SQL and fundamentals of relational database"--

Details

Files

Reviews

Download

Title Statements

Full title :Oracle SQL for secure relational databases / Richard Earp (author), emeritus associate professor, Department of Computer Science, University of West Florida, Pensacola, FL, USA, Sikha Bagui (author), professor, Department of Computer Science, University of West Florida, Pensacola, FL, USA.

Summary

Edition Statements

Publication Date:2021

Publication Statements

Publisher(s):Nova Science Publishers
Place of Publication:New York
Language:eng
Publication Date:2021

The Physical Object

Description:1 online resource.

Edition Identifiers

ISBN:1536194808, 9781536194807
oclc:on1243514471
LC Classification:QA76.73.S67
Dewey Decimal:005.75/6

Intro -- 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 -- …

Subjects

Bases de données -- Interrogation Bases de données -- Sécurité Bases de données relationnelles Database security online searching Querying (Computer science) Relational databases SQL (Computer program language) SQL (Langage de programmation)