Hi, This might sound like a bit of a daft question, but if a user got hold of a Firebird 1.52 .fdb file, how secure is the SYSDBA password in it? That is,...
Richard Mace
RichardM@...
Oct 1, 2005 7:09 am
67116
Hoi Richard, ... Usernames and passwords are server wide in Firebird. If a user has your datafiles, he can get into your database. Then again, this is true for...
... Condsider a dedicated server (running only Firebird) where the OS is on C: and the databases are on other (physical) disks (D:, E: ...) and ther server is...
Many thanks, Helen. My guys will be going through your points one-by-one next week, and hopefully making our system faster and more robust as a result. Ian....
Anyone have any ideas on this one? Can 1.0.3 make use of multiprocessors? Should I use CPU_AFFINITY on a multi-proc Windows 2003 machine or on a Windows 2003...
Hi Rick! You could use NOT EXISTS in the latter queries to avoid duplicates, e.g. select a, 1 from tablea a1 union select b, 2 from tableb b1 where not...
... Hi Richard. To add to Martijn's comments. The SYSDBA password is not held in the particular databases FDB file, but rather another security database. I am...
It would be quicker for you to test it yourself than to wait for a response from knowledgable users who probably haven't used anything earlier than 1.5 in the...
... No. However, it's also a question of what happens if you run the server without assigning the cpu_affinity to a single processor. You get the see-saw...
... Adam and Martijn, Thanks very much for your answers. Richard...
Richard Mace
RichardM@...
Oct 2, 2005 7:41 am
67126
I'm not succeeding in understanding permissions on Embedded Firebird. I created a DB successfully, but now, although I can access its metadata (e.g. table...
I'm creating a slackware 10.2 package for my own use of Firebird-1.5.3-RC1. When Firebird 1.5.3 goes public, I'll probably submit the package for public...
Hi All, There's something bothering me on using SUBSTRING. I've tried this : CREATE PROCEDURE SPTEST AS declare variable vFrom integer; declare variable vTo...
... At the point where you create a database, it becomes "owned" by the server user that created it. Most likely, that was SYSDBA. Let's assume also that you...
I need to do a search on a table in a Firebird db, looking for the occurence of two words in a particular piece of text. The words are indexed in the table...
... All of these are genuine error codes, all relating to an unknow token (keyword) in your DSQL statement. ... Sure you can, but make sure that *both* hits on...
Hello, Could any one tell me what causes the error shown below. Our system is: RedHat 9, Firebird-1.5.2 SS, jdbc-1.5.5JDK_1.4 and JBoss 4.0.1sp1. The error...
Hello everybody, I've got a question concerning "insert select from". What is supposed to do a statement like this one : insert into a_table_name select * from...
Hi, ... a_table_name (yes, with the same table name) according to the SQL standard ? ... question because I don't ... of rows and duplicated data, Correct. ......
On the weekend I tried to backup and restore a database to reorganize it. The restored failed with duplicate keys in a primary key constraint. How is this...
Thanks Ann. I am pretty sure it is garbage collection now. Looks like my app had a stuck transaction. A further question though. I fixed the app but the...
The Firebird book states that LTRIM and RTRIM take a 32,765 byte input string. My copy of Firebird 1.5 has a CString input and output of 80 characters. Which...
Rick Debay
rdebay@...
Oct 3, 2005 2:04 pm
67140
BTW, is it safe to use the ODBC driver with libfbembed in a multithreaded Unix or Windows program that does direct connect to the database file (i.e connect ...
Would there be ill effects if I were to create several symlinks to the same file, and super server connect to each of them x times? I would imagine it would be...
... You can declare it any length you need (up to a 32,765 byte maximum). 80 is just an arbitrary number (actually, the number of bytes on one line of a 90's...
Yeah, that's what I'm going to have to do, but with only two because I can't have any duplicates, and I can only supress one form of them in the Where clause. ...
Rick Debay
rdebay@...
Oct 3, 2005 2:19 pm
67144
Apologies if the appears twice, but it doesn't appear to have been sent the first time. Ann; Thanks. I am pretty sure that garbage collection is the culprit....
