Yes, this is the intended behaviour (although I can't find where it actually documented). Passwords are stored using a one-way encryption and this encrypted form applies to all Oracle platforms. It is used, for example, during export/import of full dumps where the users are created on the new (import) database with the same password they had on the old (export) database simply by copying the encrypted form. This must be cross-platform/version, and exp/imp is cross-platform/version. You can do the same thing as exp/imp does by:
CREATE USER <user> IDENTIFIED BY VALUES <encrypted form>
eg
CREATE USER TEST IDENTIFIED BY VALUES '7A0F2B316C212D67';
Note, though that the encrypted form of the password is dependent on the username for which it applies, so you cannot use this to set the same password for a differently named user.
- Bill.
At 06:14 20/12/2002 -0800, you wrote:
Same on linux 7.2 Oracle 8.1.7 rel 3 Ron >>> [EMAIL PROTECTED] 12/20/02 04:07AM >>> BOB, its the same on my machine... 8.1.6 on NT -Venu-----Original Message----- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:56 AM To: Multiple recipients of list ORACLE-L Subject: RE: password created a user test identified by test on 2 separate systems in db's with different names The password value was the same Can someone verify if it is the same on their system Create user test identified by test; select password from dba_users where username = 'TEST'; PASSWORD ------------------------------ 7A0F2B316C212D67 -----Original Message----- on my db LTRACK1 SQL> select password from dba_users where username = 'TEST'; PASSWORD ------------------------------ 7A0F2B316C212D67 bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
-- Intasys Billing Technologies Ltd. www.intasysbilling.com 74 Commercial Street, Commercial Quay, Leith, Edinburgh EH6 6LX tel (0)131 625 8200 fax (0)131 625 8201 email [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
