Tool or command to reset the SYSDBA password

Asked By wexler huddard 10 points N/A Posted on - 04/07/2012

Hi

Iam using InterBase 4x, and iam running a Linux server. I have lost my SYSDBA password. How do i reset the same password? I would like to know if there is any tool or command to reset the SYSDBA password so that i can check the database.

Thanks

 

• Status: Open
• Question Views: 2701
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Interbase / Firebird

Best Answer by Gideon Yasti

Go To Solution

Best Answer

Best Answer

Answered By Gideon Yasti 15 points N/A #107992

Tool or command to reset the SYSDBA password

 

Hy,

You are using Linux server in your desktop or laptop. There have some tips to recover or reset your lost password. Here following the method to recover your previous and set a new password:

At first open your computer windows with your administrator id.  So you should choose administrator group for do that.
Now use the following command in your linux  sqlplus /nolog
Then connect / as sysdba

Then you will be connected with that server. Now you need to change your password. Here you will set a fresh and memorable password for your future use.

 

Thanks

About Gideon Yasti

Questions
3

Answers
316

Best Answers
69

• Vote Up 0 Vote Down

• Posted on - 04/29/2012
• Question Category: Interbase / Firebird

Answered By Skarbos Jay 0 points N/A #107993

Tool or command to reset the SYSDBA password

Hi,

I can give you the syntax to reset or change the sysdba password on your computer.

>>alter user [username] identified by [new password]

>>Please note that SYSDBA is not a user. The password which you quote will be the default password for a particular user called SYS.

>>SYSDBA is a privilege which allows it’s user to do some powerful things such as ‘create a database’

This would help you to reset your password.

Thanks and regards,

Skarbos Jay.

About Skarbos Jay

Questions
5

Answers
204

Best Answers
53

• Vote Up 0 Vote Down

• Posted on - 12/11/2012
• Question Category: Interbase / Firebird