Subject | Re: [firebird-support] Change database to single user |
---|---|
Author | Milan Babuskov |
Post date | 2009-02-05T19:48Z |
Flávio Costa wrote:
CONNECT trigger that will throw an exception to other users if database
owner is connected (check in MON$ATTACHMENTS). Of course, in such
scenario you would only use the owner account to upgrade the metadata.
--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com
> But how can I connect to database and be sure I'm the only one connectSELECT from MON$ATTACHMENTS
> that everyone that try to connect after me will not succeed?As already noted you can use gfix. Alternatively you could set up ON
CONNECT trigger that will throw an exception to other users if database
owner is connected (check in MON$ATTACHMENTS). Of course, in such
scenario you would only use the owner account to upgrade the metadata.
--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com