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

Home -> Community -> Usenet -> c.d.o.server -> Re: whither user trace file?

Re: whither user trace file?

From: EdStevens <quetico_man_at_yahoo.com>
Date: 3 Aug 2005 07:59:37 -0700
Message-ID: <1123081177.698389.50990@g14g2000cwa.googlegroups.com>


DOH! Username in trigger definition was lower case, so of course the condition was never met. Made it upper case, and condition was met, but then I got

oracle_at_ncens181: sqlplus orcluser/orcluser

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Aug 3 08:54:50 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:

ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges
ORA-06512: at line 5


even after graning ORCLUSER 'alter session' and 'execute any procedure'.

So, what privilege is he still lacking? Received on Wed Aug 03 2005 - 09:59:37 CDT

Original text of this message

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