Packt+ | Advance your knowledge in tech

You're reading from Oracle 11g Anti-hacker's Cookbook Make your Oracle database virtually impregnable to hackers using the knowledge in this book. With over 50 recipes, you'll quickly learn protection methodologies that use industry certified techniques to secure the Oracle database server.

Product type Paperback

Published in Oct 2012

Publisher Packt

ISBN-13 9781849685269

Length 302 pages

Edition 1st Edition

Languages

SQL

Tools

Oracle Database

Concepts

Database Administration

Author (1):

Adrian Neagu

View More author details

Table of Contents (16) Chapters

Oracle 11g Anti-hacker's Cookbook

Credits

Foreword

About the Author

About the Reviewers

www.PacktPub.com

Preface

1. Operating System Security

2. Securing the Network and Data in Transit FREE CHAPTER

3. Securing Data at Rest

4. Authentication and User Security

5. Beyond Privileges: Oracle Virtual Private Database

6. Beyond Privileges: Oracle Label Security

7. Beyond Privileges: Oracle Database Vault

8. Tracking and Analysis: Database Auditing

Index

Creating and using Oracle Database Vault realms

A realm is a core Oracle Database Vault structure that provides logical protection against users with any type of object-level privilege. A realm can be defined on any object in any schema. In this recipe, we will use both the PL/SQL interface and Oracle Database Vault Administrator (DVA) for defining realms.

Getting ready

In this chapter, we will create a realm named HR_TABLES_REALM by using the PL/SQL interface. This realm will include all the tables from the HR schema. Next, we will create a realm named HR_VIEWS_REALM by using DVA Console. This realm will include all the views from the HR schema. The user HR will be defined as the realm owner and the users vw_america and vw_europe will be defined as the realm participants.

Note

Before you start, you must have Oracle Database Vault installed. Details on installation can be found in the documentation page http://docs.oracle.com/cd/E11882_01/server.112/e23090/dvca.htm#CIAIHIDA and on deinstallation...