RE: looping synonyms and auditing
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <joe_dba@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Sep 2006 10:46:04 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Joe Smith
Sent: Tuesday, September 19, 2006 9:18 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: looping synonyms and auditing
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
