Re: sys.aud$

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Tue, 08 Feb 2005 21:47:10 +0100
Message-ID: <489i01hcc6a4i6jflg7cgp4tbjqavoed6g@4ax.com>

On 8 Feb 2005 11:56:40 -0800, premmehrotra_at_hotmail.com wrote:

>
>Michel Cadot wrote:
>> <premmehrotra_at_hotmail.com> a écrit dans le message de
>> news:1107792894.359758.109480_at_g14g2000cwa.googlegroups.com...
>>
>>
>> | Are you suggesing that I should create my own view simlar to
>> | dba_aduit_trail,
>> | dba_audit_session in my own schema which go to aud$ as well as my
>> | table. That seems some work.
>>
>> Yes, that's what i suggested.
>>
>> | I wonder why Arup will show an example
>> | like wha I have posted ealier is his book.
>>
>> Can't answer for him. Ask him.
>>
>> Regards
>> Michel Cadot
>
>Anyone else has ideas on this.

You should leave the Oracle provided views alone. If you modify them, you would also need to modify catalog.sql I would consider this a hacked installation, and I don't think Oracle will support any modification.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Feb 08 2005 - 14:47:10 CST