WG: password iin dba_users - Oracle 11

You could use the dbms_metadata package: SELECT dbms_metadata.get_ddl('USER','user_name') from dual;

-----Ursprüngliche Nachricht-----

Von: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] Im Auftrag von Rob Gesendet: Montag, 19. Januar 2009 12:45
An: oracle-l_at_freelists.org
Betreff: password iin dba_users - Oracle 11

Hi there,

In Oracle 10 I use a script to export my users and import in another database. We now installed oracle 11 and when I query the dba_users view, the password isn't shown. Is there a parameter to enable this again? Or is there another view to use?

I googled around but couldn't find anything....

Regards,

LegeDoos
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 19 2009 - 05:58:03 CST