| {SET DEFAULT CHARACTER SET charset} | {SET LINGER TO seconds | DROP LINGER} | {ENCRYPT WITH plugin_name [KEY key_name] | DECRYPT}; Операторы DDL 95 ::= ADD FILE файла. charset Новый набор символов по умолчанию для базы данных. seconds Задержка в секундах. plugin_name Имя плагина шифрования. key_name Имя ключа шифрования. Оператор ALTER DATABASE изменяет структуру NULL] [COLLATE collation] ::= '![!info>]' ::= | [TYPE OF] domain | TYPE OF COLUMN rel.col

password Password of the user as the database owner. When using the Legacy_Auth authentication plugin, only the first 8 characters are used. Case-sensitive rolename The name of the role whose rights DEFAULT CHARACTER SET charset Chapter 5. Data Definition (DDL) Statements 110 | {ENCRYPT WITH plugin_name [KEY key_name] | DECRYPT} | SET LINGER TO linger_duration | DROP LINGER | SET DEFAULT Duration of linger delay in seconds; must be greater than or equal to 0 (zero) plugin_name The name of the encryption plugin Chapter 5. Data Definition (DDL) Statements 111 Parameter Description key_name

DEFAULT CHARACTER SET charset | SET LINGER TO linger_duration | DROP LINGER | {ENCRYPT WITH plugin_name [KEY key_name] | DECRYPT} ::= ADD [ ...] linger_duration Dauer der linger Verzögerung in Sekunden; muss größer oder gleich 0 (null) sein plugin_name Der Name des Verschlüsselungs-Plugins key_name Der Name des Verschlüsselungsschlüssels Die linger-verzögerung von 30 Sekunden ALTER DATABASE SET LINGER TO 30; 8. Verschlüsseln der Datenbank mit einem Plugin namens DbCrypt Chapter 5. Anweisungen der Datendefinitionssprache (DDL) 103 ALTER DATABASE ENCRYPT

is only displayed from Firebird version 2.0 onwards, and some options — for example “Wire crypt plugin” — depend on the type of connection. SQL> show database; Database: localhost:employee Owner: Transaction - oldest snapshot = 237 Transaction - Next = 244 ODS = 13.0 Database not encrypted Wire crypt plugin: ChaCha Default Character set: NONE No parameters, such as a specific database name, are required SQL> show mapping; WIN_ADMINS USING PLUGIN WIN_SSPI FROM PREDEFINED_GROUP DOMAIN_ANY_RID_ADMINS TO ROLE RDB$ADMIN *** Global mapping *** WIN_ADMINS_GLOBAL USING PLUGIN WIN_SSPI FROM PREDEFINED_GROUP DOMAIN_ANY_RID_ADMINS

it. If security is a concern (as it should be), you should not use the Legacy_Auth authentication plugin or enable it only temporarily while you upgrade your existing clients to Firebird 5.0. The legacy [ [ ...]] [TAGS ( [, ...]] DROP USER username) [USING PLUGIN _plugin_name] ::= PASSWORD 'password' | FIRSTNAME 'firstname' | MIDDLENAME 'middlename' 'middlename' | LASTNAME 'lastname' | {GRANT | REVOKE} ADMIN ROLE | {ACTIVE | INACTIVE} | USING PLUGIN plugin_name ::= tag_name = 'tag_value' | DROP tag_name Tags are optional key-value

Database information request Requests database or server information. Client Int32 Operation code (op_info_database) Int32 Database handle Int32 Incarnation of object (0) Buffer Requested information request This is similar to Database information request. Client Int32 Operation code (op_transaction_info) Int32 Database handle Int32 Incarnation of object (0) Buffer Requested information items Chapter items • isc_info_sql_select • isc_info_sql_describe_vars • isc_info_sql_sqlda_seq • isc_info_sql_type • isc_info_sql_sub_type • isc_info_sql_length • isc_info_sql_scale • isc_info_sql_field •

335741039 gfix_opt_SQL_dialect -sql_dialect set database dialect n 0 335544875 bad_debug_format Bad debug info format -84 335544554 nonsql_security_rel Table/procedure has non-SQL security class defined -84 gbak_redir_ouput_missing Redirect location for output is not specified -901 336986116 fbsvcmgr_info_err Unknown tag (@1) in info_svr_db_info block after isc_svc_query() -901 335740933 gfix_replay_req Replay log pathname specified -901 336723988 gsec_err_modify Modify record error -901 336330772 gbak_blob_info_failed Gds_$blob_info failed -901 335740948 gfix_retry Please retry, specifying an option -901 335544341 infunk

Device type not specified -901 336330772 gbak_blob_info_failed Gds_$blob_info failed -901 336330773 gbak_unk_blob_item Do not understand BLOB INFO item -901 336330774 gbak_get_seg_failed Gds_$get_segment -901 336330782 gbak_rel_req_failed Gds_$release_request failed -901 336330783 gbak_db_info_failed gds_$database_info failed -901 336330784 gbak_no_db_desc Expected database description record -901 336330785 manager error -902 335544436 sqlerr SQL error code = -902 335544448 bad_sec_info -902 335544449 invalid_sec_info -902 335544470 buf_invalid Cache buffer for page invalid -902 335544471

infona No information of this type available for object specified -901 336330772 gbak_blob_info_failed Gds_$blob_info failed -901 335740948 gfix_retry Please retry, specifying an option -901 336723988 gsec_err_modify 335544341 infunk Unknown information item -901 336330773 gbak_unk_blob_item Do not understand BLOB INFO item %ld -901 336723989 gsec_err_find_mod Find/modify record error -901 335544342 integ_fail Action specified -901 336920607 gstat_sysmemex System memory exhausted -901 336330783 gbak_db_info_failed gds_$database_info failed -901 336723999 gsec_pw_specified Password already specified -901 336330784 gbak_no_db_desc

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 10.2. Index Jump Info . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Value Description HDR_password_file_key 0x09 Key to compare with the password database. HDR_backup_info 0x0a Write Ahead Log (WAL) backup information. No longer used. HDR_cache_file 0x0b Shared cache level. Level zero indicates a leaf node. 10.2. Index Jump Info Following on from the above, at byte 0x22 on the page, is an Index Jump Info structure. This is defined as follows: struct IndexJumpInfo