Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: whither user trace file?
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
![]() |
![]() |