Re: Paswoord veranderen in Firebird

Article View: be.comp.programming

Article #3496

Back to be.comp.programming Previous Next

#3496

From: JVB
Date: Wed, 24 Dec 2003 01:16

26 lines
2052 bytes

"Matthijs Laan" <matthijsln@nospam-remove.xs4all.nl> schreef in bericht
news:Xns945B72C273A7matthijsln@news.xs4all.nl...
> JVB wrote:
>
> > In Firebird is het administrator account SYSDBA met paswoord
> > "masterkey" . Hoe kan ik dit paswoord veranderen met Delphi code ?
> > Dank bij voorbaat .....
>
> 30 seconden googlen:
>
> modify sysdba -pw geheim
>
> Matthijs

Matthijs, dank voor jouw hulp, alhoewel de oplossing daar toch niet te
vinden was. Ik heb zelf wat geexperimenteerd en ziehier een oplossing, met
onderstaande pascal- code lukt dit prima :

With SQLQuery1 do
begin
        Sql.Clear;
        SQL.Add('Update Users Set Passwd = ''test'' Where User_Name =
''SYSDBA''');
        ExecSQL();
end;

Technical Details

Message-ID: <MN5Gb.93730$Vk5.4163639@phobos.telenet-ops.be>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!priapus.visi.com!orange.octanews.net!news.octanews.net!news-out.visi.com!petbe.visi.com!in.100proofnews.com!in.100proofnews.com!aotearoa.belnet.be!news.belnet.be!ossa.telenet-ops.be!phobos.telenet-ops.be.POSTED!not-for-mail

References: <Lj4Gb.93650$DY4.4083773@phobos.telenet-ops.be> <Xns945B72C273A7matthijsln@news.xs4all.nl>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: 107324,7180beeca7f42477
X-Google-Attributes: gid107324,public
X-Google-Thread: fcea4,7180beeca7f42477
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2003-12-23 17:16:28 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!priapus.visi.com!orange.octanews.net!news.octanews.net!news-out.visi.com!petbe.visi.com!in.100proofnews.com!in.100proofnews.com!aotearoa.belnet.be!news.belnet.be!ossa.telenet-ops.be!phobos.telenet-ops.be.POSTED!not-for-mail
From: "JVB" <jvbsoft.verwijder.dit@pandora.be>
Newsgroups: be.comp.programming,nl.comp.programmeren
References: <Lj4Gb.93650$DY4.4083773@phobos.telenet-ops.be> <Xns945B72C273A7matthijsln@news.xs4all.nl>
Subject: Re: Paswoord veranderen in Firebird
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <MN5Gb.93730$Vk5.4163639@phobos.telenet-ops.be>
Date: Wed, 24 Dec 2003 01:16:28 GMT
NNTP-Posting-Host: 81.83.13.237
X-Complaints-To: abuse@telenet.be
X-Trace: phobos.telenet-ops.be 1072228588 81.83.13.237 (Wed, 24 Dec 2003 02:16:28 MET)
NNTP-Posting-Date: Wed, 24 Dec 2003 02:16:28 MET
Organization: Telenet Internet

Reply to Parent Message