[firebird-support] Re: Starting auditing session

2017-02-21 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, wrote : > I've started looking into Firebird tracing capabilities and there seems to > be very little documentation on the topic besides the official manual and > a few commercial applications that are well known. Does you read

[firebird-support] Starting auditing session

2017-02-21 Thread ch...@vp44.net [firebird-support]
Hi all. I've started looking into Firebird tracing capabilities and there seems to be very little documentation on the topic besides the official manual and a few commercial applications that are well known. I am aware of the "fbtracemgr" utility but I would like to handle things myself.

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

2017-02-21 Thread 'Alan McDonald' a...@meta.com.au [firebird-support]
Thanks for this Alan. Unfortunately when connected under the ROLE RDB$ADMIN, this still results in an error as RDB$USERS is an unknown table. Same goes for replacing this with USERS. As stated in Helen Borrie's The Firebird Book (p.729): "From Firebird 2.0 onward, the USER table is replaced by

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

2017-02-21 Thread cerrogrand...@yahoo.ca [firebird-support]
Thanks for this Alan. Unfortunately when connected under the ROLE RDB$ADMIN, this still results in an error as RDB$USERS is an unknown table. Same goes for replacing this with USERS. As stated in Helen Borrie's The Firebird Book (p.729):"From Firebird 2.0 onward, the USER table is replaced by

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

2017-02-21 Thread 'Alan McDonald' a...@meta.com.au [firebird-support]
In a production environment using Firebird v2.5, we need to delegate authority of USER CRUD operations to more than one person without these admins sharing the SYSDBA user and password. These admins have been created as users with ADMIN ROLE, and are logged in under the RDB$ADMIN ROLE (eg

[firebird-support] Delegating SYSDBA and enumerating users

2017-02-21 Thread cerrogrand...@yahoo.ca [firebird-support]
In a production environment using Firebird v2.5, we need to delegate authority of USER CRUD operations to more than one person without these admins sharing the SYSDBA user and password. These admins have been created as users with ADMIN ROLE, and are logged in under the RDB$ADMIN ROLE (eg in

[firebird-support] dropping the connection

2017-02-21 Thread Nick Upson n...@telensa.com [firebird-support]
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 solution needs to be automatic and unattended. db_workbench doesn't have a timeout

[firebird-support] Re: Error registered in Windows event Viewer

2017-02-21 Thread michael.vilhelm...@microcom.dk [firebird-support]
Thanks for the answer. Mivi

[firebird-support] Re: Error registered in Windows event Viewer

2017-02-21 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
21.02.2017 15:53, michael.vilhelm...@microcom.dk wrote: > > ANS4005E Error processing > '\\db07\c$\ProgramData\firebird\fb_lock_068acd221200a400': file > not found > > What does this mean? > > Should I be worried? Nothing to worry about. Some MS or 3rd party software (backup? antivirus?)

[firebird-support] Error registered in Windows event Viewer

2017-02-21 Thread michael.vilhelm...@microcom.dk [firebird-support]
Hi We have a server running Firebird 2.5.6 SuperServer.On a Windows 64 bits. Every once in a while we get this in the Event Viewer: ANS4005E Error processing '\\db07\c$\ProgramData\firebird\fb_lock_068acd221200a400': file not found Eventid: 4099 Source: AdsmClientService