Re: [firebird-support] Table Size
Ed, FB TraceManager parses gstat output and give you table/index size (MB), percentage of total database size etc. but actually does not have charting in that area. Check out screens here: http://www.upscene.com/fb_tracemanager/media * Table Stats Monitoring, and * Index Stats Monitoring -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > I have a number of growing databases on my server and would like to > occasionally see how much space each table is taking in the > database--there may be some log files that could be cleaned up now and > then. Many of my tables include blob fields, so this becomes different > than just doing record count times the amount of data in a record. > > Does anyone have any tools that they can recommend that could help me > easily manage this? > > much appreciated, > > Ed Dressel > > >
[firebird-support] In Firebird 3x, can I log in as a different user within same session? How?
Background: I'm trying to use ScriptCase to build a PHP front end for an existing Firebird 2.5 DB project. Mission critical change tracking in this project is years old, is self contained, and relies on CURRENT_USER. Precursor to Problem: In ScriptCase, the entire project logs in as SYSDBA (or any "high level" user I choose). (ScriptCase has it's own user control system and change logging which I don't need and don't want) Problem: Because ScriptCase logs in as a high level user, all existing change tracking built into the Firebird DB will log all changes by all ScriptCase users as SYSDBA (or what ever high level user was used to log in) Possible Solution: If Firebird 3x has an SQL command that would allow a currently connected user to switch their login to a different user, then there is a spot in the ScriptCase login process that I could issue that SQL. Of course, I would supply the correct Login ID and password, and I would expect all security restrictions on the session to be adjusted to the new login ID. Question: Does FB3x have such an SQL command that allows a currently logged in user to log in as a different user? Many months ago I read somewhere that this is possible, but now I can't find any documentation on how to do it. Thanks in advance for any help you can provide.
