. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 1.3. Reporting Errors or Missing Content. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 624 14.3.2. SET TRUSTED ROLE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . based on the Firebird 4.0 Release Notes and feature documentation. 1.2.1. Contributors Direct Content • Dmitry Filippov (writer) • Alexander Karpeykin (writer) • Alexey Kovyazin (writer, editor)

(destructive) access rights to all your Firebird databases. Its password should be known to a few trusted database administrators only. Therefore, you shouldn’t use this super-account to create and populate following command: create global mapping trusted_auth using plugin win_sspi from any user to user Chapter 5. Server configuration and management 25 Trusted_auth is just a chosen name for the mapping by the Win_Sspi plugin would be bob in every database. With the mapping in effect, the “Windows trusted” connection succeeds: SQL> connect xnet://employee; Database: xnet://employee, User: SOFA\PAUL SQL>

(destructive) access rights to all your Firebird databases. Its password should be known to a few trusted database administrators only. Therefore, you shouldn't use this super-account to create and populate with a Firebird username and password, which the server checks against the security database. 2. Trusted: The user is automatically identified by his OS account name. 3. Mixed: The user either supplies configuration and the way Firebird is used, trusted may be the most secure option. If trusted authen- tication is used when the connection is made (this is possible in the trusted and mixed models), Windows administrators

language, do consider translating some sections into your first language. 1.2.3. Contributors Direct Content • Dmitry Filippov (writer) • Alexander Karpeykin (writer) • Alexey Kovyazin (writer, editor) editor, coordinator) • Paul Vinkenoog (writer, designer) • Dmitry Yemanov (writer) Resource Content • Adriano dos Santos Fernandes Chapter 1. About the Firebird SQL Language Reference: for Firebird images, text, digital sounds. The basic structural unit is a segment. The blob subtype defines its content CHAR(n), CHARACTER(n) n characters. Size in bytes depends on the encoding, the number of bytes

...................................................................................... 540 SET TRUSTED ROLE ........................................................................................... строка подключения содержит имя сервера (или IP адреса), то будет предпринята попытка доверенной (trusted) авторизации к удалённому серверу. Если авторизация прошла, то удалённая операционная система назначит пользователя для утилиты gsec может потребоваться больше параметров, таких как -user и -pass, или -trusted. Использование роли RDB$ADMIN в базе данных пользователей Для управления учётными записями пользователей

. . . . . . . . . . . . . . . . . . . . . . . . . . . 569 Inhaltsverzeichnis 12 14.1.2. SET TRUSTED ROLE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Betriebssystemen können Betriebssystemkonten verwendet werden. Die Windows-Authentifizierung (auch bekannt als Trusted Authentication) kann aktiviert werden, indem das Win_Sspi-Plugin in die AuthServer-Liste in firebird Benutzers können beim Aufruf von gsec weitere Parameter benötigt werden, z. -user und -pass oder -trusted. Verwenden der Rolle RDB$ADMIN in der Sicherheitsdatenbank Um Benutzerkonten über SQL zu verwalten

подключения содержит имя сервера (или IP адреса), то будет предпринята попытка доверенной (trusted) авторизации к удалённому серверу. Если авторизация прошла, то удаленная операционная система назначит операционной системы Windows (при условии использования сервером доверенной авторизации - trusted authentication), даже без указания роли. Даже владелец роли не может использовать GRANTED BY, если операционной системы Windows (при условии использования сервером доверенной авторизации - trusted authentication), даже без указания роли. Использование роли RDB$ADMIN в обычной базе данных Для

-fetch_password -role -trusted (use trusted authentication) -database -z available commands: adding

two-phase recovery -tra(nsaction) shutdown transaction startup -tru(sted) use trusted authentication -u(se) use full or reserve space for versions -user Supplies the role name to use for the username specified.  Firebird 3 onwards. -tru[sted] Use trusted authentication. If you have not defined the above environment variables, some commands will not

............................................................................................. 2 Trusted Authentication on Windows ...................................................................... security_database.txt in the upgrade directory beneath the root directory of your installation. Trusted Authentication on Windows (V.2.1) On Windows, the default authentication mode is “Mixed”, which