Oracle Database 12c Security Cookbook

Zoran Pavlovic, Maja Veselica

• Publisher: Packt Publishing
• Year: 2016
• eBook ISBN: 9781782172123
• Edition: 1
• Topic: Computer Science
• Subtopic: Databases
• Index: Computer Science

Secure your Oracle Database 12c with this valuable Oracle support resource, featuring more than 100 solutions to the challenges of protecting your data

About This Book

• Explore and learn the new security features introduced in Oracle Database 12c, to successfully secure your sensitive data
• Learn how to identify which security strategy is right for your needs – and how to apply it
• Each ?ecipe' provides you with a single step-by-step solution, making this book a vital resource, delivering Oracle support in one accessible place

Who This Book Is For

This book is for DBAs, developers, and architects who are keen to know more about security in Oracle Database 12c. This book is best suited for beginners and intermediate-level database security practitioners. Basic knowledge of Oracle Database is expected, but no prior experience of securing a database is required.

What You Will Learn

• Analyze application privileges and reduce the attack surface
• Reduce the risk of data exposure by using Oracle Data Redaction and Virtual Private Database
• Control data access and integrity in your organization using the appropriate database feature or option
• Learn how to protect your databases against application bypasses
• Audit user activity using the new auditing architecture
• Restrict highly privileged users from accessing data
• Encrypt data in Oracle Database
• Work in a real-world environment where a multi-layer security strategy is applied

In Detail

Businesses around the world are paying much greater attention toward database security than they ever have before. Not only does the current regulatory environment require tight security, particularly when dealing with sensitive and personal data, data is also arguably a company's most valuable asset - why wouldn't you want to protect it in a secure and reliable database? Oracle Database lets you do exactly that. It's why it is one of the world's leading databases – with a rich portfolio of features to protect data from contemporary vulnerabilities, it's the go-to database for many organizations.

Oracle Database 12c Security Cookbook helps DBAs, developers, and architects to better understand database security challenges. Let it guide you through the process of implementing appropriate security mechanisms, helping you to ensure you are taking proactive steps to keep your data safe. Featuring solutions for common security problems in the new Oracle Database 12c, with this book you can be confident about securing your database from a range of different threats and problems.

Style and approach

Each chapter explains the different aspects of security through a series of recipes. Each recipe presents instructions in a step-by-step manner, supported by explanations of the topic.

Oracle Database 12c Security Cookbook

---

Oracle Database 12c Security Cookbook

Copyright © 2016 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the authors, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

First published: May 2016

Production reference: 1270516

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham B3 2PB, UK.

ISBN 978-1-78217-212-3

www.packtpub.com

Credits

Authors Zoran Pavlović Maja Veselica	Project Coordinator Shweta H. Birwatkar
Reviewers Gokhan Atil Dmitri Levin Osama Mustafa Arup Nanda Kenneth Roth	Proofreader Safis Editing
Commissioning Editor Kevin Colaco	Indexer Hemangini Bari
Acquisition Editor Kevin Colaco	Graphics Kirk D'Penha
Content Development Editors Neeshma Ramakrishnan Deepti Thore	Production Coordinator Shantanu N. Zagade
Technical Editor Gaurav Suri	Cover Work Shantanu N. Zagade
Copy Editor Dipti Mankame

About the Authors

Zoran Pavlović has worked on various complex database environments including RAC, ASM, Data Guard, GoldenGate, and so on. Areas of his expertise are security, performance/SQL tuning and high availabilty/disaster recovery of Oracle database. He has been working as an instructor for Oracle University since 2010 and during that time he has trained more than 200 students in Europe. In the last couple of years, Zoran has also been working on projects for Oracle Consulting. He is an Oracle ACE and he has been featured speaker/author at many conferences/magazines. He was actively engaged in beta testing Oracle Database 12c. Currently, Zoran is working as an Oracle Technical Architect in Parallel d.o.o. Belgrade.

I would like to take this opportunity to acknowledge some important people in my life who continuously inspire and support me. First, I want to say thank you to my parents Milenko and Stanojka Pavlovic, for everything they taught me, and for all the support they gave me during all these years. Second, I would like to say thank you to my family and my good friends, who helped me become a better person and a better professional. I am very thankful to our excellent team of technical reviewers: Arup Nanda, Gokhan Atil, Dmitri Levin, Osama Mustafa, and Kenneth Roth for their great suggestions and a very helpful feedback. I am also very thankful to Maja Veselica (it was a pleasure writing this book with you), all the editors, and everyone involved in this book.

Maja Veselica, MSc in software engineering, is currently working for Parallel d.o.o., Belgrade, as an Oracle Database consultant (security, performance tuning, and so on). She has been working as an instructor for Oracle University since 2010. In th...

Table of contents

• Oracle Database 12c Security Cookbook