Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
Undocumented but provides support for the DBMS_ITRIGGER_UTL package and affects trigger functionality in materialized views, and advanced and streams replication.
dbms_internal_trigger.destroy(
canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2,
trigger_type IN CHAR);
exec dbms_internal_trigger.destroy('UWCLASS', 'STATEMENT_LEVEL', 'TABLE');
BEGIN dbms_internal_trigger.destroy('UWCLASS', 'STATEMENT_LEVEL', 'TABLE'); END;
*
ERROR at line 1:
ORA-24331: user buffer too small
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 79
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 157
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 201
ORA-06512: at line 1
Overload 2
dbms_internal_trigger.destroy(
canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2,
trigger_type IN CHAR,
expact_entry IN BOOLEAN);
exec dbms_internal_trigger.destroy('UWCLASS', 'STATEMENT_LEVEL', 'TABLE', FALSE);
BEGIN dbms_internal_trigger.destroy('UWCLASS', 'STATEMENT_LEVEL', 'TABLE'); END;
*
ERROR at line 1:
ORA-24331: user buffer too small
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 79
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 159
ORA-06512: at line 1
dbms_internal_trigger.make(
canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2,
trigger_type IN CHAR);
exec dbms_internal_trigger.make('UWCLASS', 'SERVERS', 'TABLE');
BEGIN dbms_internal_trigger.make('UWCLASS', 'SERVERS', 'TABLE'); END;
*
ERROR at line 1:
ORA-24331: user buffer too small
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 79
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 129
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 180
ORA-06512: at line 1
Overload 2
dbms_internal_trigger.make(
canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2,
trigger_type IN CHAR,
expact_entry IN BOOLEAN);
exec dbms_internal_trigger.make('UWCLASS', 'SERVERS', 'TABLE', FALSE);
BEGIN dbms_internal_trigger.make('UWCLASS', 'SERVERS', 'TABLE', FALSE); END;
*
ERROR at line 1:
ORA-24331: user buffer too small
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 79
ORA-06512: at "SYS.DBMS_INTERNAL_TRIGGER", line 131
ORA-06512: at line 1