Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!news.tiscali.de!newsfeed.freenet.de!newsfeed.kamp.net!newsfeed.kamp.net!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!o5g2000hsb.googlegroups.com!not-for-mail
From:  matthias.hoys@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: ALTER USER and the sql cache
Date: Wed, 06 Jun 2007 04:24:40 -0700
Organization: http://groups.google.com
Lines: 9
Message-ID: <1181129080.580912.80670@o5g2000hsb.googlegroups.com>
NNTP-Posting-Host: 81.246.102.250
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1181129080 25894 127.0.0.1 (6 Jun 2007 11:24:40 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 6 Jun 2007 11:24:40 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; InfoPath.1; .NET CLR 1.1.4322; .NET CLR 3.0.04506.30),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 VUURMUUR
Complaints-To: groups-abuse@google.com
Injection-Info: o5g2000hsb.googlegroups.com; posting-host=81.246.102.250;
   posting-account=5tEhiw0AAAB1HrHCkbYiOaGz5EeJsXkg
Xref: news.f.de.plusline.net comp.databases.oracle.server:199007

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