RE: alter user <name> identified by statement truncated in trace file

  • From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
  • To: <peter.schauss@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 28 Jun 2006 13:50:25 -0600

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


Other related posts: