Firebird Question:
Download Questions PDF

Why does reading require write privileges on database file?

Answer:

In order to run the SELECT statmement, it still needs to start a transaction.

If you wish to build a read-only database to place on some read-only media like CD or DVD ROM, you can do it with:

gfix -mode read_only database.fdb

...or within your favorite administration tool. It is also available via ServicesAPI, so you may do it from your application as well. Please note that you can only make this change while preparing the database, because the read-only flag needs to be written in the database file.

When the database becomes read-only, the only thing you can write to is the read_only flag (to reset it back to read-write).

Download Firebird Interview Questions And Answers PDF

Previous QuestionNext Question
Can I concurrently access a Firebird database with embedded and with regular server?What is the best way to determine whether Firebird server is running?