15 5. Server configuration and management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 5.1. User management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 5.1.2. Adding Firebird user accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 6.3.3. Creating a database as a non-privileged user . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 6.4. Firebird SQL

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 356 7.7.2. Management Statements in PSQL. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 540 11.7. CURRENT_USER. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 551 11.24. USER . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

...... 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 Firebird server executable. • One or more client libraries. • The command-line tools. • The standard user-defined function libraries. • A sample database. • The C header files (not needed by beginners). •

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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 trusted authentication -u(se) use full or reserve space for versions -user default user name -v(alidate) validate database structure -w(rite) write

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 4.2. Protecting User Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . operating system refer to relevant documentation for that operating system, to discover how to apply user and object security in Firebird databases refer to documentation available from the Firebird website 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 will authenticate the user credentials against

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 4.1. Displaying User Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 5.1. Displaying User Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . privileged user) the ability to maintain user accounts for various Firebird databases. Using various options, users can be added, amended or deleted from the security database.  A privileged user is an

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 374 9.7. CURRENT_USER. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 383 9.21. USER . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 397 11.1. User Authentication. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

server ............................................................................... 11 Default user name and password ............................................................................... executable. • A client library located on the server machine. • The command-line tools. • The standard user-defined function libraries. • A sample database. • The C header files (not needed by beginners!) can run as non-root user, e.g. firebird. This limits the damage in case of malfunctioning (by hack or otherwise). No Services Manager. Tasks like backup/ restore, user management, stats etc. have to be

.................................................................. 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 läuft, angemeldet sind. Auf Windows Ser- verplattformen müssen Sie in der Regel Mitglied der Power User Gruppe oder höher sein, um gsec erfolg- reich ausführen zu können. Probleme beim Ausführen von gsec

colectivo, dirigido a producir documentación precisa y comprensible sobre el RDBMS (Relational Database Management System, Sistema de Administración de Bases de Datos Relacionales) Firebird. Es importante entender mismo que en protocol server (servidor) cvs.sourceforge.net repository (almacén) /cvsroot/firebird user name (nombre de usuario) anonymous module name (nombre del módulo) manual cvsroot generalmente una "manual" de Firebird 8 server (servidor) cvs.sourceforge.net repository (almacén) /cvsroot/firebird user name (nombre de usuario) su nombre de usuario en SourceForge module name (nombre del módulo) manual