Re: password columns in oracle 11g

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
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: