Subject RE: [firebird-support] Embedded Issue - Multiple DDL/DML statements
Author Alan McDonald
> >Hmm,... I don't know what the difference is with my system but when I log
> >thru my embedded server to a database and I do not supply a username, the
> >USER is SYSDBA whether I like it or not.
> >I have tested this with UPDATE triggers.
>
> Yep, this will be the case if you have the envvars ISC_USER and
> ISC_PASSWORD defined (as I discovered a couple of days ago when fiddling
> about with the backup service.)
>
> ./hb

But I don't. I just tried it again after checking the env vars.
I logged on with empty username and empty password and empty role.
A trigger setting new.createuser=user
has supplied SYSDBA as the result.
Alan