Subject Re: [Firebird-Java] How to change forced writes settings via JayBird?
Author Helen Borrie
At 08:26 AM 13/10/2009, you wrote:
>> However, the code fails if I change the user name or password passed to
>> FBMaintenanceManager. I was under the impression that user name and password
>> were not required in embedded mode. Was I wrong to assume that?
>
>Any user name and password should be accepted, but it might be possible
>that absence of the user name or password is not tolerated. No clue,
>need to look into the code in debugger... Also it might be specifics of
>Services API in embedded mode...

Not specific to embedded mode, Roman. In Fb 1.5.6, 2.0.5, 2.1.3 and 2.5.anything, only the SYSDBA (or equivalent) or Owner has write access to database header settings.

An embedded client doesn't go the server authentication route, so doesn't *need* a user name and password (and won't barf if they are not in the connection parameters). But the interface should be capable of accepting and storing a username for use in Services API calls...

Beware of enabling header-changing operations in a multi-thread environment, of course, regardless of the available user credentials...

Helen