Hi all,

Helen Borrie wrote:

>> I have just created an application for backing up and restoring
>> firebird databases using gbak. I am using the firebird 1.5 embedded
>> version. When I run it from my machine and I log into Windows as
>> "Administrator" I don't have to connect as SYSDBA. But If I log
>> into Widnows as any other user I have to connect to the database as
>> SYSDBA. (...)
>
> The probable explanation is that your Administrator profile has the
> environment variables ISC_USER and ISC_PASSWORD active.
>
> If I disable isc_password in my Administrator account (Win2K), I
> can't do a gbak without supplying the password.

Another explanation is that if Administrator runs the embedded
version, the server process is owned by Administrator and thus no
login/password is required; you get automatic SYDSBA access.

I suppose that on Helen's computer - like on mine - Firebird runs as a
service; in that case it's owned by "System", not "Administrator", and
even Administrator must supply login and pass (either explicitly or
via the envvars).

If Administrator runs the server as an application, s/he's
automatically SYSDBA again.

At least, that's how it is in 1.0; I suppose it's still the same
in 1.5


Greetings,
Paul Vinkenoog