Oracle Database Application Security

TRAMA

Focus on the security aspects of designing, building, and maintaining a secure Oracle Database application. Starting with data encryption, you will learn to work with transparent data, back-up, and networks. You will then go through the key principles of audits, where you will get to know more about identity preservation, policies and fine-grained audits. Moving on to virtual private databases, you’ll set up and configure a VPD to work in concert with other security features in Oracle, followed by tips on managing configuration drift, profiles, and default users. Shifting focus to coding, you will take a look at secure coding standards, multi-schema database models, code-based access control, and SQL injection. Finally, you’ll cover single sign-on (SSO), and will be introduced to Oracle Internet Directory (OID), Oracle Access Manager (OAM), and Oracle Identity Management (OIM) by installing and configuring them to meet your needs. Oracle databases hold the majority of the world’s relational data, and are attractive targets for attackers seeking high-value targets for data theft. Compromise of a single Oracle Database can result in tens of millions of breached records costing millions in breach-mitigation activity. This book gets you ready to avoid that nightmare scenario.What You Will LearnWork with Oracle Internet Directory using the command-line and the console Integrate Oracle Access Manager with different applications Work with the Oracle Identity Manager console and connectors, while creating your own custom one Troubleshooting issues with OID, OAM, and OIDDive deep into file system and network security concepts Who This Book Is ForOracle DBAs and developers. Readers will need a basic understanding of Oracle RDBMS and Oracle Application Server to take complete advantage of this book.

SOMMARIO

Chapter 01 - EncryptionReaders will go through Transparent Data, Back-up and Network Encryption. They will learn to work with ghost data and cross border issues with networks• Transparent Data Encryption 1. Keystore 2. Column Encryption 3. Tablespace Encryption 4. External Table Encryption 5. Ghost Data a. How it happens b. How to fix it. 6. Column Encryption 7. Tablespace Encryption a. Full Database Encryption b. Online Encryption 8. External Tables 9. Algorithms• Backup encryption 1. RMAN 2. Data Pump• Network 1. Configuration a. Require b. Request c. Accepted d. Rejected 2. Cross Border Issues 3. IntegrityChapter 02 - AuditThis chapter will take readers through the audit process. They will learn about key policies and identity preservation. Readers will also take a look at how fine grain audits work.• Identity Preservation• Policy• Needs to tell 1. Who 2. What 3. When  4. Where  5. How• Fine Grained AuditChapter 03 - Virtual Private DatabaseThis chapter will teach readers key intrusion detection tools like Database Firewall and SNORT. Readers will also get tips on managing Configuration Drift, profiles and default users. • Intrusion Detection tools 1. Database Firewall 2. SNORT• Configuration Drift 1. Connections a. New b. Frequency 2. ORACLE_HOME a. Tripwire 3. Objects a. New b. Altered c. Dropped• Users 1. Object Access a. Privilege Analysis b. Grants Roles S/U/I/D/E Column c. Fine Grained Access Control (VPD)• Profiles• Default users 1. Can you drop them? 2. Default password 3. Impossible password 4. Expired 5. LockedChapter 04 - File System AccessReaders will learn about tools to access file systems.• Directories• utl_fileChapter 05 - Network access and Evaluation This chapter will teach readers about accessing networks with tools like ACL and DBSAT. Readers will also look at some network evaluation tools.• ACL• Evaluation Tools• DBSATChapter 06 - Coding Chapter will be about understanding secure coding standards. Readers will also learn about SQL Injection.• Importance of secure coding standards.• Multi-Schema database model. 1. Decorations Schema 2. Business Logic Schema 3. API Schema 4. Data Objects Schema 5. Errors / Help Desk Schema• Public Synonyms• Sys_context• Accessible by• Authid 1. Definer's rights 2. Current_user (invoker) 3. Inherit privileges• Code Based Access control• Sql injection 1. Secure shell• Error messagesChapter 07 - Single Sign On (SSO) Readers will be introduced to Oracle Internet Directory (OID), Oracle Access Manager (OAM) and Oracle Identity Management (OIM) by installing and configuring them to your needs. They will then learn to work with OID using command line and console. Chapter will also cover OAM integration with different applications and working with the OIM console.• Definition for SSO• Working with SSO 1. Oracle Internet Directory 2. Oracle Access Manager 3. Oracle Identity Access Management • Installation and Administration 1. OID  2. OAM  3. OIM • Working with Oracle Internet Directory 1. OID using command line 2. OID using console 3. Troubleshooting OID Issues.• Access Control with Oracle Access Manager 1. OAM concepts 2. Integrate OAM with different applications 3. Provide access to users with OAM 4. Troubleshooting• User Management with Oracle Identity Manager 1. OIM Concepts 2. Working with OIM console 3. OIM Connectors 4. Create your own custom connector. 5. Troubleshooting

AUTORE

Osama Mustafa is a database specialist, an Oracle ACE Director, Certified Oracle Professional (10g, 11g), Certified Ethical Hacker and Sun System Administrator. Osama currently works as an Oracle Instructor in the Middle East. He also works on troubleshooting and the implementation of database projects. He spends his free time on Oracle OTN forums and publishes many articles, including Oracle database articles, on his blog.Robert P. Lockard is an Oracle ACE Director, a professional Oracle DBA, designer, developer, and project manager with more than three decades of experience. For the past twenty years he has worked as an independent consultant providing quality services to his customers at a reasonable price. Robert has worked in financial intelligence tracking money laundering, terrorist money, and identity theft. He has also worked in the cyber crimes arena tracking attacks on information systems. He specializes in evaluating and securing your Oracle database environment from threats both external and internal.

ALTRE INFORMAZIONI

• Condizione: Nuovo
• ISBN: 9781484253663
• Dimensioni: 235 x 155 mm Ø 551 gr
• Formato: Brossura
• Illustration Notes: XVII, 341 p. 88 illus.
• Pagine Arabe: 341
• Pagine Romane: xvii