Oracle9i 9.2.0.3.0, O7_DICTIONARY_ACCESSIBILITY is FALSE. --- Jacques Kilchoer <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
