WG: password iin dba_users - Oracle 11

  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 19 Jan 2009 12:58:03 +0100

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

-----Ursprüngliche Nachricht-----
Von: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] Im 
Auftrag von Rob
Gesendet: Montag, 19. Januar 2009 12:45
An: oracle-l@xxxxxxxxxxxxx
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....




Other related posts:

  • » WG: password iin dba_users - Oracle 11 - Jan-Hendrik . Boll