filmov
tv
Oracle DDL Trigger to log all database object changes

Показать описание
DBA should track all changes to their production database.
This DDL triggers logs all Oracle databases changes to a custom table.
If TRUNCATE the trigger will ignore.
IF object_type = 'TABLE' the ddl statement such as create/drop/alter is logged.
ELSE log change information without the ddl statement.
The source is originally from link below which I have modified it slightly.
Please like, comment and subscribe. Thank you.
This DDL triggers logs all Oracle databases changes to a custom table.
If TRUNCATE the trigger will ignore.
IF object_type = 'TABLE' the ddl statement such as create/drop/alter is logged.
ELSE log change information without the ddl statement.
The source is originally from link below which I have modified it slightly.
Please like, comment and subscribe. Thank you.
Oracle DDL Trigger to log all database object changes
PL/SQL tutorial 18: DDL Trigger with Schema Auditing Example
Oracle Trigger to Block DDL by Schema Owner
System Trigger - Schema Trigger to get information of Log On in PLSQL Oracle - Practical Demo
PL/SQL tutorial 19: How To Create Database Event 'LogOn' Trigger In Oracle By Manish Shar...
Tutorial 17 : DDL TRIGGER || How to monitor Database Activity.
Oracle interview Question : what is trigger in oracle
ENABLE DDL LOGGING
Oracle 12C New Feature DDL Logging
DDL Triggers in sql server
Curso Oracle PL/SQL avanzado: CREAR TRIGGER DDL
DDL trigger -part 1
39 - DDL Trigger Example # 1
pl sql tutorial#19 Introduction of PLSQL Trigger in oracle database
DDL Triggers and Logon triggers in SQL Server
TSQL: Create DDL Trigger For Tracking Schema Changes
99/125 Oracle PLSQL: Creating Triggers / DDL Triggers
SQLChallenge: DDL Triggers - Solution
Triggers (Oracle PL/SQL)
PL/SQL tutorial 16: Table Auditing using DML Triggers in Oracle PL/SQL
DML Error Logging - Weird Trigger Behaviour
PLSQL 9 ORACLE TRIGGER LOGS
PL/SQL tutorial 20: Database Event 'Log Off' Trigger In Oracle By Manish Sharma Rebellion ...
How to Create Oracle Trigger Using Oracle SQL Developer
Комментарии