Oracle9i 9.2.0.3.0, O7_DICTIONARY_ACCESSIBILITY is FALSE.
- Jacques Kilchoer <Jacques.Kilchoer_at_quest.com> wrote:
> What database version? What is your setting for
> O7_DICTIONARY_ACCESSIBILITY?
> I tried the following in an 8.1.7 database with
> O7_DICTIONARY_ACCESSIBILITY = FALSE
>
> create user x identified by ... ;
> grant create session, create trigger to x ;
>
> (logging on as SYSDBA)
> grant execute on sys.dbms_support to x ;
>
> CONNECT X ...
> create trigger schema_trace
> after logon
> on schema
> begin
> sys.dbms_support.start_trace (waits => false, binds => false) ;
> end ;
> /
> DISCONNECT
>
> logon as user X:
> trace file created
>
> logon as user Y:
> no trace file created
>
> logon as user Y, say "alter sesssion set current_schema = X ;"
> no trace file created
>
> No error messages in alert log
>
> > -----Original Message-----
> > From: Paul Baumgartel [mailto:treegarden_at_yahoo.com]
> >
> > In an attempt to catch all SQL issued by a report, I created a
> logon
> > trigger in the report's logon schema. (As SYS, I granted the user
> > EXECUTE on DBMS_SESSION before creating the trigger.) As the
> schema
> > owner, I am able to execute DBMS_SESSION.SET_SQL_TRACE
> interactively.
> >
> > On logon, trace files are created, but they contain the following:
> >
> > *** SESSION ID:(27.4739) 2003-07-22 18:52:53.000
> > Skipped error 604 during the execution of RPT_PERF.TRACE_ALL
> > *** 2003-07-22 18:52:53.000
> > ksedmp: internal or fatal error
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-01031: insufficient privileges
> > ORA-06512: at "SYS.DBMS_SESSION", line 126
> > ORA-06512: at line 2
> >
> >
> > When SQL statements are executed in the session, no further trace
> > information is added to the file.
> >
> > Anyone know what's going on here?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jacques Kilchoer
> INET: Jacques.Kilchoer_at_quest.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
Received on Wed Jul 23 2003 - 09:02:42 CDT