Re: Updating ALL_TRIGGERS

On 8 Apr 2003 12:14:01 +0100, "Frank" <franjoe_at_frisurf.no> wrote:

>Hi!
>
>Regarding Oracle 8.1.6/Windows2000
>
>I am told that someone had updated ALL_TRIGGERS to disable/enable triggers
>and succeded, personally I wouldn't dear to do that,
>but I get in doubt as it is a new version(for me) of Oracle and many things
>changes for each version :-)
>
>Is it recommeded/documented to do/not to do(in any version of Oracle)?
>
>Frank
>
>PS: If it is Oracles intention is that these views/tables are not to be
>changed, why dont they block them better, even for SYSTEM?
>

It is recommended and documented NOT to do this, and you will loose support if Oracle finds out.

PS: You can't protect a database against developers/dba's purposively trying not to read documentation and only willing to hack their way out.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Apr 08 2003 - 12:11:00 CDT