Subject RE: [firebird-support] reset sysdba password without loose existing users
Author Edward Mendez
Post date 2017-03-24T02:59:24Z

Hi,

 

What the person meant was that if a database is opened using a firebird server process, that process looks for a valid password for the sysdba user. This is the situation you are in now.  

 

But, If you take that Database and open it in embedded mode, meaning that it isn’t using the server process. The Embedded mode only looks for the user to exist. It doesn’t care about the password. Once you connect, you can then issue the appropriate command to change the password.

 

Thanks,

Ed Mendez

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, March 23, 2017 1:05 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] reset sysdba password without loose existing users

 

 

Hi,

Thanks for your reply,

I don't understand what you mean....sorry

As i said, i don't have sysdba password....and i don't want to loose all
existing users account

Regards

-----Message d'origine-----
De : firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Envoyé : jeudi 23 mars 2017 17:29
À : firebird-support@yahoogroups.com
Objet : Re: [firebird-support] reset sysdba password without loose existing
users

23.03.2017 17:27, startx252000@... [firebird-support] wrote:

> Anybody can help me to reset SYSDBA without loose all existing users in
Firebird

Attach in embedded mode with SYSDBA name and you can change the password
with ALTER
USER command.

--
WBR, SD.

------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu
there.

Also search the knowledgebases at
http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links