Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: password
Oracle7 Server Release 7.3.4.5.0 - Production
With the distributed, parallel query and Spatial Data options
PL/SQL Release 2.3.4.5.0 - Production
SQL> create user test identified by test;
User created.
SQL> select password from dba_users where username = 'TEST';
PASSWORD
SQL> drop user test;
User dropped.
SQL> create user hohoho identified by test;
User created.
SQL> select password from dba_users where username = 'HOHOHO';
PASSWORD
SQL> drop user hohoho;
User dropped.
-----Original Message-----
Sent: Tuesday, December 17, 2002 8:24 PM
To: Multiple recipients of list ORACLE-L
SQL*Plus: Release 9.2.0.2.0 - Production on Tue Dec 17 17:19:55 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
SQL> create user test identified by test;
User created.
SQL> select password from dba_users where username = 'TEST';
PASSWORD
7A0F2B316C212D67
SQL>
-----Original Message-----
Sent: Tuesday, December 17, 2002 2:26 PM
To: Multiple recipients of list ORACLE-L
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
-----Original Message-----
on my db
LTRACK1 SQL> select password from dba_users where username = 'TEST';
PASSWORD
bob
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wiegand, Kurt INET: Kurt.Wiegand_at_CWUSA.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesReceived on Wed Dec 18 2002 - 05:08:40 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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).
![]() |
![]() |