RE: [firebird-support] Delegating SYSDBA and enumerating users

2017-02-22 Thread 'Alan McDonald' a...@meta.com.au [firebird-support]
Hi Alan and all, Thanks for this further insight into your approach. I am quite new to FB, but from what I have read I am wondering a few things with this approach. First looking at Borrie's 2nd edition (p. 729): "From Firebird 2.0 onward, the USER table is replaced by one named RDB$USERS

Re: [firebird-support] Delegating SYSDBA and enumerating users

2017-02-22 Thread cerrogrand...@yahoo.ca [firebird-support]
Hi Alan and all, Thanks for this further insight into your approach. I am quite new to FB, but from what I have read I am wondering a few things with this approach. First looking at Borrie's 2nd edition (p. 729):"From Firebird 2.0 onward, the USER table is replaced by one named RDB$USERS and

Re: [firebird-support] dropping the connection

2017-02-22 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, wrote : > Killing connections by deleting from MON$STATEMENTS requires Firebird > 2.5 and an ODS 11.2 database (so you will also need to backup and > restore the database when migrating to Firebird 2.5!). MON$ATTACHMENTS ;) Regards, Vlad

Re: [firebird-support] dropping the connection

2017-02-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2017-02-21 17:32, Nick Upson n...@telensa.com [firebird-support] wrote: > Hi > > The problem I'm trying to solve is users leaving inactive db_workbench > sessions attached to a database while other work is going on by other > processes, causing a large OIT gap and the consequent problems. The