Hi thanks Ed,



embedded mode ? so must i connect to security2.fdb file with gsec command option ?





De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Envoyé : vendredi 24 mars 2017 03:59
À : firebird-support@yahoogroups.com
Objet : RE: [firebird-support] reset sysdba password without loose existing users





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





[Non-text portions of this message have been removed]