5.11. PACKAGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215 5.11.1. CREATE PACKAGE. . . . 11.2. ALTER PACKAGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 218 5.11.3. CREATE OR ALTER PACKAGE . . . . . . 5.11.4. DROP PACKAGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220 5.11.5. RECREATE PACKAGE . . . . . . .

...... 14 Server configuration and management ................................................................................................... 15 User management: gsec ............................. Firebird 2.0 and 2.1 Quick Start 4 The Firebird licenses Firebird is a free, open-source database management system, but “free” does not mean that everything is per- mitted. The use of Firebird is governed with FirebirdSS, Classic packages with FirebirdCS. For Windows, there is a combined installation package; you choose the architecture during the installation process. Embedded Server for Windows On Windows

15 5. Server configuration and management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 5.1. User management . . . . . . . . . . . . . . . About this guide 3 Chapter 2. The Firebird licenses Firebird is a free, open-source database management system, but “free” does not mean that everything is permitted. The use of Firebird is governed bbbb-p-linux-x64.tar.gz Linux compressed tarball Firebird-5.0.0.bbbb-p-macos-x64.pkg Mac OS-X 64-bit package ...where bbbb is the build number (e.g. 1227 for Firebird 5.0.0 Release Candidate 1) and p the

of malfunctioning (by hack or otherwise). No Services Manager. Tasks like backup/ restore, user management, stats etc. have to be performed locally using the client tools (small separate executables) that Firebird. Features a Services Manager enabling you to perform certain tasks (backup/restore, user management, stats, etc.) programmatically. You can connect to the Services Manager over the network and thus install Firebird. The Windows executable installa- tion script, the Linux rpm (RPM Package Manager, originally RedHat Package Manager) program and the official .tar.gz for other Posix platforms perform some

. . . . . . . . . . . . . . . . . . . . . . . . . . . . 402 11.1.4. SQL Statements for User Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 402 11 by developers to communicate, through their applications, with the Firebird relational database management system. It has a long history. 1.1. Subject Matter The subject matter of this volume is wholly Keywords The primary construct in SQL is the statement. A statement defines what the database management system should do with a particular data or metadata object. More complex statements contain simpler

5.11. PACKAGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 202 5.11.1. CREATE PACKAGE. . . . 11.2. ALTER PACKAGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204 5.11.3. CREATE OR ALTER PACKAGE . . . . . . 5.11.4. DROP PACKAGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 206 5.11.5. RECREATE PACKAGE . . . . . . .

SQL СУБД Firebird 3.0 9 PACKAGE .............................................................................................................................. 194 PACKAGE .......................... ................................................................................... 194 CREATE PACKAGE .............................................................................................. 194 .................................................................................... 198 ALTER PACKAGE ................................................................................................

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 6. Limbo Transaction Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . database utility. • Shadow file handling. • Cache and buffer handling. • Transaction management. • Cache management. • Starting and stopping a database. • And much, much more … Chapter 1. Introduction buffers" Page buffers 4000 Chapter 5. Set Database Page Buffers 11 Chapter 6. Limbo Transaction Management Limbo transactions can occur when an application is updating two (or more) databases at the same

will lose the ability to make effective use of database indexes and search facilities — and key management remains a major problem (more below). Chapter 3. The Problem 5 Chapter 4. The Solution There issue is not really whether encryption is practicable or useful, but a matter of whether key management would provide a solution to the problems we are examining. Encryption can only be as good as the which purport to provide strong encryption. Perhaps the encryption is strong but, unless the key management is in place to support this feature, the encryption is not going to achieve the desired effect

Firebird 2.5. Since Firebird 2.1, Windows domain administrators have had full access to the user management functions. This meant that when an admin user connected to the server and then used gsec, they above will cause all Windows Administrator accounts to automatically have full access to the user management functions. The automatic mapping can be revoked as follows: SQL> SQL> alter role rdb$admin drop Firebird 2.5. Since Firebird 2.1, Windows domain administrators have had full access to the user management functions. This meant that when an admin user connected to the server and then used gsec, they