Re: Updating ALL_TRIGGERS

Frank 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?

Just curious - did they do this in their own schema or in the SYSTEM schema? And if in the SYSTEM schema, are they considered a DBA?

1. If a non-DBA, what are they doing in the SYSTEM schema? Does this imply a security issue in the environment?
2. If a DBA, do they need updated training?