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

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Wed, 28 Jun 2006 13:50:25 -0600
Message-ID: <7209E76DACFED9469D4F5169F9880C7A282EF4@mail01bldr.arraybp.com>

It is a security feature.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter Sent: Wednesday, June 28, 2006 1:48 PM
To: oracle-l_at_freelists.org
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
--

http://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.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 28 2006 - 14:50:25 CDT