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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: looping synonyms and auditing

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

Original text of this message

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