. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 10.3. Manual Garbage Collection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . and for multi-file databases, it is the first data file added. Coming up in the remainder of this manual, we will discuss the following: • Command line options for the gfix database utility. • Shadow trusted authentication -u(se) use full or reserve space for versions -user default user name -v(alidate) validate database structure -w(rite) write

.............................................................................................. 15 User management: gsec ................................................................................ start with a Firebird binary kit. The guide first saw the light as Chapter 1 of the Using Firebird manual, sold on CD by IBPhoenix. Later it was published separately on the Internet. In June 2004, IBPhoenix Embedded Server, consult the Clients and Servers chapter in Using Firebird: http://www.firebirdsql.org/manual/ufb-cs-embedded.html (HTML) http://www.firebirdsql.org/pdfmanual/Using-Firebird_(wip).pdf (PDF)

while Firebird 2.x also has the nbackup utility which is described in another document. In this manual, we will discuss: • Command-line options for gbak. • gbak commands and their parameters. • Running password for the appropriate user to be read from a file as opposed to being specified on the command line. The file name supplied is not in quotes and must be readable by the user running gbak. If the file file name is specified as stdin, then the user will be prompted for a password. On POSIX systems, the file name /dev/tty will also result in a prompt for the password.  Firebird 2.5 onwards. -M[ETA_DATA]

server ............................................................................... 11 Default user name and password ............................................................................... Chapters 4-6 of the Using Firebird manual, distributed on the IB- Phoenix CD. The Firebird Quick Start Guide started life as Chapter 1 of the Using Firebird manual, sold on CD by IBPhoenix. Later it was 1.5 or higher, get the appropriate version of the Quick Start Guide at http://www.firebirdsql.org/manual/ (HTML) or http://www.firebirdsql.org/pdfmanual/ (PDF). What is in the kit? All of the kits contain

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 10. Setting The ISC_USER And ISC_PASSWORD Environment Variables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Introduction This manual provides reference material for the Firebird Interactive SQL Utility (isql), and instructions on how to use it to perform tasks within the database.  This manual is a work in progress restructuring as new versions appear. 1.1. Audience This manual assumes prior knowledge of basic database concepts. 1.2. Version This manual describes the isql utility in Firebird version 1.5 and higher

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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

версией руководства Quick Start Guide, которую можно получить по ссылке http://www.firebirdsql.org/manual/ (HTML) или http://www.firebirdsql.org/pdfmanual/ (PDF). Что в комплекте? Каждый пакет содержит серверной машине. • Утилиты командной строки. • Стандартные библиотеки пользовательских функций (user-defined function libraries, UDF). • Образец базы данных. • Заголовочные файлы языка C (не требуются серверных системах Windows для использо- вания утилиты gsec, обычно, Вы должны быть членом группы Power User или другой правомочной группы. Если Вы уверены, что у Вас достаточно привилегий, но использование

Cómo obtener y construir el módulo "manual" de Firebird Paul Vinkenoog Traducción al castellano: Ernesto Cullen 2 Tabla de contenidos Introducción: propósito de esta guía - A quién se dirige ..... . 3 En definitiva, ¿qué es este "módulo manual"? ................................................................................. 3 ¿Además del módulo "manual", hay alguna otra documentación de Firebird documentos yo mismo? ¿No hay una forma más sencilla? ............... 3 Obtener el módulo Firebird manual de SourceForge ................................................................................

производительность WITH {AUTONOMOUS|COMMON} TRANSACTION WITH CALLER PRIVILEGES ON EXTERNAL [DATA SOURCE] AS USER, PASSWORD и ROLE Параметризованные операторы Предостережения для оператора EXECUTE STATEMENT IN CREATE USER ALTER USER DROP USER 11. Контекстные переменные CURRENT_CONNECTION 6 Руководство по языку SQL CURRENT_ROLE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_TRANSACTION CURRENT_USER DELETING переменные; • Операторы и предикаты (утверждения); • Агрегатные функции; • Встроенные функции; • UDF (User Defined Functions — функции, определённые пользователем. Также известные как внешние функции). Полная