Re: sys.aud$

Anurag Varma wrote:
> Michel's reply was all you needed.
> You should create your own views similar to dba_audit_trail and
> dba_audit_session.
>
> Lookup the original view definition of the dba view:
>
> set long 10000
> select view_text from dba_views where view_name = 'DBA_AUDIT_TRAIL';
>
> You would then create your own views:
>
> create or replace my_audit_trail
> as
> select .......
> from (select * from sys.aud$ union all select * from
> myschema.myaudittable) aud, .....
> /

Anurag:
That's what I started doing, but wanted to make sure whether there are any shortcuts.  

Thanks. As always, appreciate your useful responses.

Prem Received on Tue Feb 08 2005 - 16:31:06 CST