Project

Poor Man's Data Vault

Description

The goal is simple, have a simple, easy to use version of Oracle's Data Vault. By no means is this trying to replace their product, it's just a simple solution to help lockdown your Oracle database.

Goals

1. Prevent unknown DDL in a production environment
• When known:
1. Capture INVALID objects prior to DDL
2. Capture INVALID objects after DDL
3. Capture all changed objects during deployment window

Installation Instructions

Can be found here.

Diagrams

Flow Diagram

Data Model - I will be moving the model over from Visio to the 2.0 Production release of SQL Developer Data Modeler. The xml file can now be downloaded from Source.

Package: PMDV_WORK_PKG

CREATE_WORK Flow

RECONNECT Flow

END_WORK Flow

SET_CONTEXT Flow

Requirements

List of conditions that DDL can be performed.

Pre-installation

You can install a trigger and table to capture DDL prior to the full deployment of PMDV. This will allow you to add exceptions specific to your environment.

Screenshots

PMDV Work

PMDV Work Details