Subject Re: Hibernate, alter table and single user
Author jeffrobertsky@yahoo.com
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
> Note the following:
>
> 1) You can alter database objects without having exclusive access,
but you
> will get "object in use" if any transaction is currently using the
object.
> You can keep trying if you want to.
>
> 2) You can not add or drop foreign key constraints UNLESS you have
both
> exclusive access AND no other transaction running.
>
> I should probably write a How-to for getting exclusive access...

I guess my question, then, is...as shipped, does sysdba/masterkey
have exclusive access, or does it take the gfix -shut to make it so?

To put it another way, I've only created a database as
sysdba/masterkey, I've created no users, and all I've done is to run
the Hibernate sample program, so is there any reason I would NOT
have exclusive access at this point?

Thanks for your patience,
-Jeff