Book Image

Oracle Database 12c Security Cookbook

By : Zoran Pavlovic, Maja Veselica
Book Image

Oracle Database 12c Security Cookbook

By: Zoran Pavlovic, Maja Veselica

Overview of this book

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.
Table of Contents (18 chapters)
Oracle Database 12c Security Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface

Restricting access to program units by using accessible by


In this recipe, you'll learn about the effects of using the accessible by clause.

Getting ready

To complete this recipe, you'll use a user who has the create procedure privilege.

How to do it...

  1. Connect as a user who has the create procedure privilege (for example, zoran):

    SQL> connect zoran
    
  2. Create the protected_pkg package that is only accessible by public_pkg:

    CREATE OR REPLACE PACKAGE protected_pkg   
       ACCESSIBLE BY (public_pkg)
    IS
       PROCEDURE protected_proc;
    END;
    /
    CREATE OR REPLACE PACKAGE BODY protected_pkg
    IS
       PROCEDURE protected_proc
       IS
       BEGIN
             DBMS_OUTPUT.PUT_LINE ('This is a Protected Procedure
                 that can only be accessed from Public Package');
          END;
    END;
    /
    
  3. Create the public_pkg package:

    CREATE OR REPLACE PACKAGE public_pkg
    IS
          PROCEDURE public_proc;
    END;
    /
    CREATE OR REPLACE PACKAGE BODY public_pkg
    IS
          PROCEDURE public_proc
          IS
          BEGIN
             DBMS_OUTPUT.PUT_LINE...