Re: not able to turn on sql_trace for an instance

From: Harald Maier <maierh_at_myself.com>
Date: Sat, 23 Aug 2003 08:22:37 +0200
Message-ID: <m3brugyjte.fsf@ate.maierh>

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> writes:

> You don't mention one great advantage of this approach which is that you can
> DISABLE/ENABLE triggers. I prefer calling DBMS_SUPPORT (can you tell) in a
> SCHEMA logon trigger because you can grant execute on DBMS_SUPPORT to the
> relevant accounts without granting ALTER SESSION and because you are doing
> it at the schema level rather than the db level. Imagine an error in a db
> level logon trigger.....

I am looking into the 'Supplied PL/SQL Packages and Types Reference (a96612)' and I cannot find a documentation for the package 'dbms_support'. The same is true for the package 'dbms_system'. Exists another document that describes this packages?

Harald Received on Sat Aug 23 2003 - 01:22:37 CDT