Database reference - HR

HR -  triggers -  HR.SECURE_EMPLOYEES

Description

secure_employees BEFORE INSERT OR UPDATE OR DELETE ON employees

Trigger properties

namevalue
nameHR.SECURE_EMPLOYEES
base object typeTABLE
parentEMPLOYEES
typeBEFORE STATEMENT
eventINSERT OR UPDATE OR DELETE
action typePL/SQL
referencing namesREFERENCING NEW AS NEW OLD AS OLD
statusDISABLED

Dependency graph

SECURE_DMLEMPLOYEESSECURE_EMPLOYEES

Objects that HR.SECURE_EMPLOYEES depends on

nameobject typelevel
SECURE_DMLstored procedure1
EMPLOYEEStable1

Code

  CREATE OR REPLACE TRIGGER "HR"."SECURE_EMPLOYEES" 
  BEFORE INSERT OR UPDATE OR DELETE ON employees
BEGIN
  secure_dml;
END secure_employees;
ALTER TRIGGER "HR"."SECURE_EMPLOYEES" DISABLE
 



Documentation generated by SqlSpec