Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ALTER USER and the sql cache

ALTER USER and the sql cache

From: <matthias.hoys_at_gmail.com>
Date: Wed, 06 Jun 2007 04:24:40 -0700
Message-ID: <1181129080.580912.80670@o5g2000hsb.googlegroups.com> 





Oracle 10.2.0.3 on Linux.



When I issue a statement like 'ALTER USER scott IDENTIFIED BY newpwd',
I can't fnd the query in the shared pool query cache (v$sql). Is there
a security mechanism in place which protects against caching these
kind of queries ?



Matthias
Received on Wed Jun 06 2007 - 06:24:40 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US