Re: password columns in oracle 11g
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: joan.hsieh@xxxxxxxxx
- Date: Wed, 19 May 2010 08:01:42 +0200
Or if you don't want to mess with undocumented tables, you can also use
set long 10000
select dbms_metadata.get_ddl('USER',username) from dba_users;
to get the information.
Stefan
=========================
Stefan P Knecht
CEO & Founder
s@xxxxxxxx
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch
=========================
On Tue, May 18, 2010 at 8:58 PM, Joan Hsieh <joan.hsieh@xxxxxxxxx> wrote:
> Hi Listers,
>
> In oracle 10g, if we need to refresh the test database from prod database,
> we reserve all the users/schema's password on test databases by extract the
> encrypted password column from dba_users and reset the password by using the
> command " alter user identified by values " "; from the pre refresh process
> after refresh. In oracle 11g, the password column in dba_users is null, it
> seems we lost the ability to reserve the original password. I have opened
> the SR with oracle for over 3 weeks, they still didn't give me any
> solutions. I am wondering if someone knows better.
>
> Thanks in advance,
>
> Joan
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
