Home » RDBMS Server » Server Administration » User management(urgent) (10g (10.1.0.5.0),linux RHEL3)
User management(urgent) [message #364791] Wed, 10 December 2008 01:19 Go to next message
sounderraj.l
Messages: 10
Registered: November 2008
Location: Bangalore
Junior Member
Hello DBA's

can any body explain me, how to trace user name & password from existing database and to create the same user name with same password to make my test success.
i am performing user level export and import on 10g db





thanks in advance....


regards RAJ

Re: User management(urgent) [message #364796 is a reply to message #364791] Wed, 10 December 2008 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> select dbms_metadata.get_ddl('USER','SCOTT') from dual;
DBMS_METADATA.GET_DDL('USER','SCOTT')
-----------------------------------------------------------------

   CREATE USER "SCOTT" IDENTIFIED BY VALUES 'F894844C34402B67'
      DEFAULT TABLESPACE "TS_D01"
      TEMPORARY TABLESPACE "TEMP"

Regards
Michel
Re: User management(urgent) [message #364809 is a reply to message #364796] Wed, 10 December 2008 02:42 Go to previous messageGo to next message
sounderraj.l
Messages: 10
Registered: November 2008
Location: Bangalore
Junior Member
hello mic

can u explain me how to create the user with this encrypted password.
i have created the user with the encrypted password but when i try to connect again as conn scott/password it is giving error message saying. invalid username/password nolonger connected to oracle.


please reply me..


Regards
RAJ

Re: User management(urgent) [message #364813 is a reply to message #364809] Wed, 10 December 2008 02:49 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Can you connect to the original user with that password?

PS: The CREATE USER with IDENTIFIED BY VALUES will create a new user with the same password as the original user's password.
Re: User management(urgent) [message #364829 is a reply to message #364813] Wed, 10 December 2008 03:33 Go to previous message
sounderraj.l
Messages: 10
Registered: November 2008
Location: Bangalore
Junior Member

dear frank,

i worked on your solution, i am happy, thank u but still i have a doubt will there be any password mismatch onn my production database.
because there are 286 users exists. Application end users access the database through profitplus application they are connecting to the individual schemas, and they are using the same username and password for loggin. so will there be a mismatch

please explain.

once again thanking u.


Regards
RAJ
Previous Topic: 10g Upgrade
Next Topic: TRACE FILES
Goto Forum:
  


Current Time: Sun Dec 04 10:41:55 CST 2016

Total time taken to generate the page: 0.11951 seconds