Subject Re: [firebird-support] Re: Using embedded FireBird server
Author Paul Vinkenoog
Hi Darin, Adam,

>> isc_db_handle newdb = NULL;
>> isc_tr_handle trans = NULL;
>> char* create_db = "CREATE DATABASE new.fdb";
>> if(isc_dsql_execute_immediate(status_vector, &newdb, &trans,
>> 0, create_db, 1, NULL)){
>> /* Error Routine */
>> }
>> Error:
>> Your user name and password are not defined. Ask your database
>> administrator to set up a Firebird login.
>> This sounds reasonable, however from reading the documentation I
>> gathered that there is no security layer with the embedded server
>> and there should be no problem accessing the routines.

> There is a security layer, just the user security is not policed.
> You still need to provide a legitimate user with permissions in the
> database (SYSDBA is fine) and any password will be accepted.

In Darin's case, since he's creating a new database, he can come up
with any user name he likes. But he does have to provide a user name
plus password.

A funny detail is that when *creating*, username and password may
both be '' (empty string). But when *connecting* this is not accepted.
A single space is OK though.

Paul Vinkenoog