matthias.hoys_at_gmail.com wrote:
> 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
Use the ORA_SQL_TXT system event in a database level DDL trigger to
view DDL.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Jun 06 2007 - 09:53:36 CDT
