Get Oracle Databse Password I am Linked to from an Access form

[darwish]

Hello Guys

I have the following case:

I have an access Form (2013) that is linked to an oracle database.

At the first time I am connected to that database It was recommended to enter the Password for this database (1 time only)

Now i forget the password of the oracle database I am connected to.



On the ms access application I am connected to the database successfully and I am not obliged to enter the password anymore since in ms access i just enter the password only at the first time I connect to the database.

Is there a way to find the password of the database I am connected to?

Thanks for your concern

[princess12]

Hi i know this is out of my expertise but

here are two links to recover oracle database - they might help

before you try it make a back up copy of your work

https://community.oracle.com/thread/899559
http://en.kioskea.net/faq/4399-oracl...lost-passwords

hope am not breaking the rules by posting links here. hope it helps

[orange]

My guess is that there is an Oracle DBA associated with the database, and that he/she could tell you the password you were assigned (or give you a new one).

[CJ_London]

if you have a linked table, look in the MSysObject table - you'll see the password there

[darwish]

if you have a linked table, look in the MSysObject table - you'll see the password there

Dear Can you be more specific?
Is the password found in the Connect Column under name PWD?

Thank you

[CJ_London]

it is in the connect column and is usually stated as 'PWD=password' where 'password' is your password.

[darwish]

Worked

Thank you