Firebird Internals Inside a Firebird Database Norman Dunbar Version 1.2, 13 August 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 2. Database Structure. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 3. Standard Database Page Header. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 4. Database Header Page — Type 0x01

15 5. Server configuration and management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 5.1. User management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 5.1.3. The security database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 6.2. Connecting to an existing database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

5.1. DATABASE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104 5.1.1. CREATE DATABASE . . . 104 5.1.2. ALTER DATABASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110 5.1.3. DROP DATABASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353 7.6.3. Database Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

...... 14 Server configuration and management ................................................................................................... 15 User management: gsec ............................. ...... 20 Connecting to an existing database ................................................................................................ 22 Creating a database using isql ........................ .......................................................................... 28 How to corrupt a database ...............................................................................................

Firebird Database Housekeeping Utility Norman Dunbar, Mark Rotteveel Version 2.1, 13 November 2023 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5. Set Database Page Buffers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 6. Limbo Transaction Management . . . 15 8. Changing The Database Mode. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 9. Setting The Database Dialect . . . . .

about Firebird, see this link: www.firebirdsql.org This article discusses the security of Firebird database files and in particular access to the metadata stored in those files. It has been written in response Chapter 1. Introduction 2 Chapter 2. Background For an application (user) to access a Firebird database it must connect to the Firebird server process. On receiving a connect request the server process security database. If authentication is successful the server will allow the application access to any database that it requests and then use the roles and privileges defined in that database to provide

. . . . . . . . . . . 22 Table of Contents 1 Chapter 1. Introduction Gsec is the security database manipulation utility. It allows the SYSDBA (or any privileged user) the ability to maintain user various options, users can be added, amended or deleted from the security database.  A privileged user is an account on the database server which the Firebird engine considers to be privileged enough to for security reasons. The Firebird database holds details of all users in a single security database. This is located on the server in a normal Firebird database named security.fdb for Firebird 1.5 or

5.1. DATABASE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 5.1.1. CREATE DATABASE . . . 79 5.1.2. ALTER DATABASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84 5.1.3. DROP DATABASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 266 7.5.3. Database Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

................................................................... 13 Connecting to the sample database .................................................................................... 13 Server name ................................................................................. 14 Creating a database using isql .................................................................................... ................................................................................. 15 The CREATE DATABASE statement ...................................................................... 15 Performing a

.................................................................. 12 Serverkonfiguration und -management .............................................................................................. innerhalb des buildroot.tar.gz Archivs, das in diesem Kit inkludiert ist. Serverkonfiguration und -management Es gibt einige Dinge, die Sie kennen und um die Sie sich kümmern müssen, bevor Sie beginnen einen Aufruf von gsec die folgende Fehlermel- dung zur Folge hat „cannot attach to password database - unable to open database“: • Sie verwenden Firebird unter Windows und aus einem bestimmtem Grund funktioniert