Hi Dave I have had the same issue before but i don't remember the answer but I think i found it with either trace or SQL*Net trace.
I think show is a keyword implemented in SQL*Plus that simply translates into some SQL. Set trace on your session and on your users session and use tkprof with SYS = yes to collect all SQL including ddl and see if a difference is shown between your session and his, you in theory should have the same SQL as him but it could indicate where the difference lies. Or an alternative is to use SQL*Net trace at SUPPORT level and you should see the SQL used in the packet contents. hope this helps kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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).
