Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sys.aud$

Re: sys.aud$

From: <premmehrotra_at_hotmail.com>
Date: 7 Feb 2005 08:14:54 -0800
Message-ID: <1107792894.359758.109480@g14g2000cwa.googlegroups.com>

Michel Cadot wrote:
> Comments embedded.
>
> <premmehrotra_at_hotmail.com> a écrit dans le message de
> news:1107746191.214936.106750_at_c13g2000cwb.googlegroups.com...
> | I have archived some data from this table into a table of my
> | own called mdbaudarch.
> |
> | I want to use dba_audit_trail view to combine information from
aud$
> | and my table.
> |
> | I have seen following example (slightly modified) in Arup Nanda's
book:
> |
> | # create a combined view
> | #set -xv
> | sqlplus /nolog << !
> | set buffer edit;
> | conn / as sysdba;
> | create view aud\$_combined
> | as
> | select * from aud$
> | union all
> | select * from mdbaudarch.t_mdbaudarch
> | ;
> |
> | create public synonym aud\$ for sys.aud\$_combined;
> | !
>
> Don't create any object in SYS schema.
>
> |
> | When I do select * from aud$, I do see combined results,
> | but when I do select * from dba_audit_trail I only see
> | rows from sys.aud$, why.
>
> Because private objects are taken before synonyms.
> The order of precedence is: private object -> private synonym ->
public synonym
> So in the view definition table sys.aud$ is chosen and not public
synonym.
>
> |
> | What changes should I make so views such as dab_audit_session,
> | dba_audit_trail etc see both tables.
> |
>
> Create your own view in your schema.
>
> |
> |
> | Prem
> |

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. I wonder why Arup will show an example like wha I have posted ealier is his book. Received on Mon Feb 07 2005 - 10:14:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US