Trigger on Schema Changes
Posted in 2004
Topics: Stored Procedures & SPL, Security, Permissions & Auditing, Triggers, Constraints & Referential Integrity
Does Informix support adding a trigger on any database schema change, like addign a new stored procedure or changing the definition of a table. I would like to add an audit mechanism to my database and log or prevent schema changes. Thanks Alexis
some of this may be covered by the onaudit utility
alexis.kyriakides@gmail.com wrote:
> Does Informix support adding a trigger on any database schema change,
> like addign a new stored procedure or changing the definition of a
> table. I would like to add an audit mechanism to my database and log
or
> prevent schema changes.
>
>
> Thanks
> Alexis
some of this may be covered by the onaudit utility
alexis.kyriakides@gmail.com wrote:
> Does Informix support adding a trigger on any database schema change,
> like addign a new stored procedure or changing the definition of a
> table. I would like to add an audit mechanism to my database and log
or
> prevent schema changes.
>
>
> Thanks
> Alexis