OraFAQ Forum: Server Administration » User management(urgent)

Home » RDBMS Server » Server Administration » User management(urgent) (10g (10.1.0.5.0),linux RHEL3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

User management(urgent) [message #364791]

Wed, 10 December 2008 01:19

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

Report message to a moderator

Re: User management(urgent) [message #364796 is a reply to message #364791]

Wed, 10 December 2008 01:27

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: User management(urgent) [message #364809 is a reply to message #364796]

Wed, 10 December 2008 02:42

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

Report message to a moderator

Re: User management(urgent) [message #364813 is a reply to message #364809]

Wed, 10 December 2008 02:49

Frank Naude
Messages: 4581
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.

Report message to a moderator

Re: User management(urgent) [message #364829 is a reply to message #364813]

Wed, 10 December 2008 03:33

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

Report message to a moderator

Previous Topic:	10g Upgrade
Next Topic:	TRACE FILES

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 20:47:53 CST 2024