Re: password columns in oracle 11g

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Wed, 19 May 2010 08:01:42 +0200
Message-ID: <AANLkTinVPtN1faxNmHIyNV6g95ilhGff64B75W-CmA32_at_mail.gmail.com>

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_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch

---

On Tue, May 18, 2010 at 8:58 PM, Joan Hsieh <joan.hsieh_at_tufts.edu> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 19 2010 - 01:01:42 CDT