Re: [firebird-support] Forgot sysdba password

2020-04-09 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-04-09 18:05, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] wrote:
> On 2020-04-09 09:53, liviuslivius liviusliv...@poczta.onet.pl
> [firebird-support] wrote:
>> Hi
>> 
>> Simply replace security3.fdb by ine from the zip install and
>> initialize sysdba
> 
> Doing that will lose all other users in the security database, so that
> is not a good idea.
> 
> Instead, stop Firebird server, and use
> 
> isql -user sysdba employee
> 
> and then
> 
> alter user sysdba password 'new password';
> commit;
> exit;

And of course, start Firebird server again.

Mark


Re: [firebird-support] Forgot sysdba password

2020-04-09 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-04-09 09:53, liviuslivius liviusliv...@poczta.onet.pl 
[firebird-support] wrote:
> Hi
> 
> Simply replace security3.fdb by ine from the zip install and
> initialize sysdba

Doing that will lose all other users in the security database, so that 
is not a good idea.

Instead, stop Firebird server, and use

isql -user sysdba employee

and then

alter user sysdba password 'new password';
commit;
exit;

Mark


Re: [firebird-support] Forgot sysdba password

2020-04-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.04.2020 06:47, Andrea Raimondi andrea.raimo...@gmail.com [firebird-support] 
wrote:
> What I'd like to do is to reset the pw to something known

   Connect to any database in embedded mode with user name SYSDBA (without 
password) and 
use ALTER USER query.


-- 
   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

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/



RE: [firebird-support] Forgot sysdba password

2020-04-09 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
HiSimply replace security3.fdb by ine from the zip install and initialize 
sysdbaRegards,Karol Bieniaszewski
null

[firebird-support] Forgot sysdba password

2020-04-08 Thread Andrea Raimondi andrea.raimo...@gmail.com [firebird-support]
Hi!

I have googled around a bit but can't seem to find anything simple to sort
this problem out.
I may have to reinstall the thing altogether.

What I'd like to do is to reset the pw to something known (for, I am fairly
sure I can't just recover it, it'll need to be reset).

Suggestions?