Re: password iin dba_users - Oracle 11

From: Ian Cary <ian.cary_at_ons.gsi.gov.uk>
Date: Mon, 19 Jan 2009 11:52:38 +0000
Message-ID: <OF8A0EB9EA.CB551AAC-ON80257543.0041297E-80257543.00413EA5_at_ons.gsi.gov.uk>

Oracle have removed the column from the dba_users view but it it is still present in SYS.USER$.

Cheers,

Ian

|---------+----------------------------->


|         |           legedoos_at_gmail.com|

|         |           Sent by:          |

|         |           oracle-l-bounce_at_fr|

|         |           eelists.org       |

|         |                             |

|         |                             |

|         |           19/01/2009 11:45  |

|         |           Please respond to |

|         |           legedoos          |

|         |                             |

|---------+----------------------------->
  >--------------------------------------------------------------------------------------------------------------|
  |                                                                                                              |
  |       To:       oracle-l_at_freelists.org                                                                       |
  |       cc:                                                                                                    |
  |       Subject:  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



This email was received from the INTERNET and scanned by the Government
Secure Intranet anti-virus service supplied by Cable&Wireless in
partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) In
case of problems, please call your organisation’s IT Helpdesk.
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.


For the latest data on the economy and society consult National Statistics at http://www.statistics.gov.uk

*********************************************************************************


Please Note:  Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications
*********************************************************************************


Legal Disclaimer  :  Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics
*********************************************************************************


The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the GSi this email was certified virus free.
Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^

Received on Mon Jan 19 2009 - 05:52:38 CST