Re: alter system triggers
- From: Seth Miller <sethmiller.sm@xxxxxxxxx>
- To: "jcoll1970@xxxxxxxxx" <jcoll1970@xxxxxxxxx>
- Date: Sun, 5 Oct 2014 07:19:28 -0500
Are you just trying to audit the use of ALTER SYSTEM? If so, you would
probably be better off using native auditing.
On Friday, October 3, 2014, Joshua Collier <jcoll1970@xxxxxxxxx> wrote:
> Does anyone know of a trigger that will reliably fire on alter system and
> capture the commands via the objects such as :
> DBMS_STANDARD.SYSEVENT;
> NVL(DBMS_STANDARD.DICTIONARY_OBJ_OWNER,'NULL');
> DBMS_STANDARD.DICTIONARY_OBJ_TYPE;
> DBMS_STANDARD.DICTIONARY_OBJ_NAME;
>
>
> I have a trigger that is "on database before alter", however, ALTER SYSTEM
> does not trigger it. Either that or I have not yet found the correct
> dbms_standard types to capture the output. The trigger right now just
> inserts the various type values into a table. For Alter Table it works
> great, but ALTER SYSTEM produces nothing.
>
> Josh C.
>
Other related posts:
