. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 3.4.4. Session Time Zone . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 356 7.7.2. Management Statements in PSQL. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 577 13.2. SQL Statements for User Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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 C:\> set ISC_PASSWORD=masterkey  This is very insecure as it allows anyone who can access your session the ability to perform DBA functions that you might not want to allow. -role role Supplies the

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

...... 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 tree within the buildroot.tar.gz archive that's packed inside the kit. Server configuration and management There are several things you should be aware of – and take care of – before you start using your

only) help displaying version number: z (interactive only) quit interactive session: quit (interactive only) available parameters: -pw -uid 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

die von Entwicklern für die Kommunikation ihrer Anwendungen mit dem Firebird Relation Database Management System benötigt werden. 1.1. Thema Das Kernthema dieses Dokuments ist die vollständige Implementierung Möglichkeiten zum Erstellen von Datenbanken. Jaybird stellt zum Beispiel die Klasse org.firebirdsql.management.FBManager bereit, um programmgesteuert eine Datenbank zu erstellen. Bei Bedarf können Sie jederzeit TRIGGER', 'SQL_TEXT'), 'N') returning id into id; rdb$set_context('USER_SESSION', 'trig_ddl_log_id', id); end end! Der obige Trigger wird für diesen DDL-Befehl ausgelöst. Es

rdb$get_context('DDL_TRIGGER', 'SQL_TEXT'), 'N') RETURNING id INTO id; rdb$set_context('USER_SESSION', 'trig_ddl_log_id', id); END END! -- Примечание: -- созданный выше триггер будет запущен для AUTONOMOUS TRANSACTION DO UPDATE ddl_log SET ok = 'Y' WHERE id = rdb$get_context('USER_SESSION', 'trig_ddl_log_id'); END! COMMIT! SET TERM ;! -- Удаляем запись о создании trig_ddl_log_after RDB$GET_CONTEXT('USER_SESSION', 'DATEBEGIN'); END -- Возвращает дату окончания периода FUNCTION GET_DATEEND() RETURNS DATE DETERMINISTIC AS BEGIN RETURN RDB$GET_CONTEXT('USER_SESSION', 'DATEEND');

Starting An Isql Session . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 6. Ending an Isql Session . . . . . . . The isql utility can be used in three modes: as an interactive session; directly from the command line; and as a non-interactive session, using a shell script or batch file. Different tasks may be performed the modes, as illustrated below: • An interactive session can be invoked from the command line of the operating system shell, and lasts until the session is terminated, using a QUIT or EXIT command. Isql

имен - SYSTEM, USER_SESSION или USER_TRANSACTION. Тип результата: VARCHAR(255) Синтаксис: RDB$GET_CONTEXT ('', '') ::= SYSTEM | USER_SESSION | USER_TRANSACTION ::= регистрочувтвительная строка с максимальной длиной 80 символов Пространство имён: USER_SESSION и USER_TRANSACTION изначально пусты. Пользователь может создать и установить значение переменных CURRENT_USER Глобальная переменная CURRENT_USER CURRENT_ROLE Глобальная переменная CURRENT_ROLE SESSION_ID Глобальная переменная CURRENT_CONNECTION TRANSACTION_ID Глобальная переменная CURRENT_TRANSACTION

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 Windows on Windows.) Chapter 4. Default disk locations 17 Chapter 5. Server configuration and management There are several things you should be aware of — and take care of — before you start using your