looping synonyms and auditing

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Tue, 19 Sep 2006 08:18:26 -0500
Message-ID: <BAY121-F364C57C2BE00C9B020ABC697220@phx.gbl>

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

sys_at_ORCL> create or replace public synonym DBA_AUDIT_TRAIL for DBA_AUDIT_TRAIL
  2 /

Synonym created.

sys_at_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_at_ORCL> audit session whenever successful;

Audit succeeded.

Elapsed: 00:00:00.02
sys_at_ORCL> audit session whenever not successful;

Audit succeeded.

Elapsed: 00:00:00.01
sys_at_ORCL> audit connect whenever successful;

Audit succeeded.

Elapsed: 00:00:00.04
sys_at_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

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

Received on Tue Sep 19 2006 - 08:18:26 CDT