CREATE OR REPLACE PROCEDURE populate_time_table (v_start_date IN date, v_end_date IN date) as /* DESCRIPTION: This procedure will populate the TIME table completely, based on entering a start and end date for the table data. REVISIONS: Ver Date Author Description ———
How to create a dynamic Oracle audit trigger
CREATE OR REPLACE PROCEDURE CREATE_AUDIT_TRIGGER (v_table_name IN VARCHAR2, — Table Name. v_enabled IN VARCHAR2 DEFAULT ‘Y’) — Enable Trigger on creation? IS /* DESCRIPTION: This procedure creates a standard audit trigger for a standard audit table. REVISIONS: Ver Date Author
How to create an Oracle dynamic audit table
CREATE OR REPLACE PROCEDURE CREATE_AUDIT_TABLE (v_table_name IN VARCHAR2, — Table Name that already exists. v_init_extent IN NUMBER := 10240, — Initial Extent – also used for Next Extent in K v_init_storage IN NUMBER := 10240) — Initial Table Storage in
How to create trigger audits with Oracle DDL
The script below (a trigger) audits and records information about DDL occurring in the current schema, recording the OS login name, the terminal, the session user, the command issued, the object type involved, and the object name. create table audit_events
How to check users are not trying to change other users passwords
The trigger below will check to see that user George is only changing his own password and not trying to change other peoples passwords. create procedure reset_password (p_username in varchar2, p_password in varchar2) as begin if (USER=’GEORGE’ and p_username in