RE: looping synonyms and auditing

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 19 Sep 2006 10:46:04 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF2709939804@AABO-EXCHANGE02.bos.il.pqe>

Hi Joe,

I don't have experience with auditing, so I won't comment on that question.

As to the looping chain of synonyms, what user are we connected as? What if you try this, as SYS:
 create or replace public synonym DBA_AUDIT_TRAIL for sys.DBA_AUDIT_TRAIL;  grant select on sys.DBA_AUDIT_TRAIL to select_catalog_role;

Did that work?

-Mark

--

Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

"A human being should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly. Specialization is for insects." --Robert A. Heinlein

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Smith Sent: Tuesday, September 19, 2006 9:18 AM To: oracle-l_at_freelists.org
Subject: looping synonyms and auditing

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 19 2006 - 09:46:04 CDT