It is a security feature. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Schauss, Peter Sent: Wednesday, June 28, 2006 1:48 PM To: oracle-l@xxxxxxxxxxxxx Subject: alter user <name> identified by statement truncated in trace file Oracle 8.1.7.4 (cpuJanuary2006) AIX 5.2 While trying to determine what command a third party application is using to change users' passwords I discovered that the ALTER USER <name> IDENTIFIED BY statement is getting truncated when written to a trace file. For example ===================== PARSING IN CURSOR #3 len=38 dep=0 uid=31 oct=43 lid=31 tim=0 hv=2271055062 ad='3 25aafc0' alter user test identifie END OF STMT PARSE #3:c=0,e=0,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=0 XCTEND rlbk=0, rd_only=1 ===================== Is this a bug or a feature? Thanks, Peter Schauss -- //www.freelists.org/webpage/oracle-l This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system. -- //www.freelists.org/webpage/oracle-l