Need to edit a oracle DB from windows ?? 2

[droodle]

I need to install an editor of some kind so i can copy some user account passwords within a solaris 9i DB .. can this be done with some sort of editor running on a windows box and connect from there ?

IF so which editor to use ? i've tried freeware toad but that just hangs as soon i i try and run it on 2 diferent servers.

thanks.

 

[KenCunningham]

I'm not sure I fully understand the requirement, but could you use sqlplus vi an Oracle client on the PC?

I want to be good, is that not enough?

 

[droodle]

ok what i need to do ..

I have a 9i db on solaris .. i need to access the users and copy the encrypted password from a user for whos password i know - eg mine and then paste it into another user ie admin im told this is the only way to recover the password and i don't not enough about db's to do it from a command line and wanted to use a graphical tool such as toad but can't get that working.

thanks.

 

[KenCunningham]

Do you have dba access to the database, since I would imagine you would need these privileges to do so. If so, at the command line it's just a case of alter user <username> identified by <newpassword> to change the password. You can probably do the same using Enterprise Manager if you have access to it.

I want to be good, is that not enough?

 

[droodle]

Are you sure this is all i have to do .. i will try it but .. i've been told to retreve a password from a known user, its incrypted. then write it in to the password cell on the admin user, all with sql statments

 

[droodle]

just to make things clear this is not a oracle db account its a user name and password within the db for a specific application.

 

[LKBrwnDBA]

User passwords in the database are encrypted and the value computed depends on the user name (id), therefore even if you can assign the password encrypted value to another user, you may not be able to logon (retrieve it).

If you need to logon to a certain user account without knowing the password, use this time-tested trick:

set echo off term off
----------------------------------------------------------------
--
--  db_su.sql
--
--  Connect as another user
--
------------------------------------------------------------------
-- Parameter 1: User to connect to
CLEAR
def user=&1
set pages 0 feed off verify off
spool /tmp/temp.sql
select 'alter user &user identified by values '||chr(39)||password||chr(39)||';'
from dba_users
where username = UPPER('&user')
/
spool off
alter user &user identified by temp;
connect &user/temp
START /tmp/temp.sql
set pages 23 feed on verify on echo on term on

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

Ooooh! did'nt read the "... this is not a oracle db account...".

My bad.

Then what you need to do is copy the table rows/columns which contain the application user/password?

If TOAD did not work for you, use the Enterprise Manager Console:

For each database:

Click on Database -> Schema -> Tables

Right click on source table -> View/Edit contents

Copy and paste the data from one db to another.




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[droodle]

well i worked it out .. and installed a client on my local machine (doh) then used toad, and successfully changed my password - thanks to those that replied.