Tool or command to reset the SYSDBA password

Asked By 10 points N/A Posted on -
qa-featured

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

 

SHARE
Best Answer by Gideon Yasti
Go To Solution
Best Answer
Best Answer
Answered By 15 points N/A #107992

Tool or command to reset the SYSDBA password

qa-featured

 

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
Answered By 0 points N/A #107993

Tool or command to reset the SYSDBA password

qa-featured

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

Structure to capture an ISAM error

Previous

Datatype to capture and display image in FoxPro

Next

Related Questions