looping synonyms and auditing

  • From: "Joe Smith" <joe_dba@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 19 Sep 2006 08:18:26 -0500

How do you fix a looping chain of syns? Drop the synonym and recreate the public synonym?

sys@ORCL> create or replace public synonym DBA_AUDIT_TRAIL for DBA_AUDIT_TRAIL
2 /


Synonym created.

sys@ORCL> grant select on DBA_AUDIT_TRAIL  to select_catalog_role
 2  /
grant select on DBA_AUDIT_TRAIL  to select_catalog_role
               *
ERROR at line 1:
ORA-01775: looping chain of synonyms






What is the difference between these two? Metalink has a doc 99786.1 about audit connect.


audit session

audit connect

Oracle will take both entries:

sys@ORCL> audit session whenever successful;

Audit succeeded.

Elapsed: 00:00:00.02
sys@ORCL> audit session whenever not successful;

Audit succeeded.

Elapsed: 00:00:00.01
sys@ORCL> audit connect whenever successful;

Audit succeeded.

Elapsed: 00:00:00.04
sys@ORCL> audit connect whenever not successful;

Audit succeeded.


Will Oracle do both?

audit session whenever successful
audit session whenever not successful

Will Oracle record both successful and not successful attempts? Or one or the other?

thanks.

_________________________________________________________________
All-in-one security and maintenance for your PC.  Get a free 90-day trial! http://clk.atdmt.com/MSN/go/msnnkwlo0050000001msn/direct/01/?href=http://www.windowsonecare.com/?sc_cid=msn_hotmail


--
//www.freelists.org/webpage/oracle-l


Other related posts: