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!) Server 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

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] be used by the connecting user. Not of much practical use and is not normally used in practice. -U[SER] Allows the username of the SYSDBA or database owner user to be specified if the database

................................................. 29 Running Firebird as a service with a special user name .......................................................... 30 Installing Multiple Servers . to server security, it also isolates the mechanisms of authentication from the implementation. • User accounts can now be configured only by using the Services API or the gsec utility. • For backing Non-SYSDBA users no longer can see other users' accounts in the security database A non-privileged user can retrieve or modify only its own account and it can change its own password. Remote attachments

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 540 11.7. CURRENT_USER. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 551 11.24. USER . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 569 13.1. User Authentication. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

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

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

замечания ......................................................................................... 367 AS USER, PASSWORD и ROLE .......................................................................... 367 Предостережения .................................................................................... 392 CURRENT_USER ................................................................................................. ............................................................................................. 405 USER .................................................................................................

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

производительность 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 — функции, определённые пользователем. Также известные как внешние функции). Полная

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 496 11.7. CURRENT_USER. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 507 11.23. USER . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 532 13.2.1. CREATE USER. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 532 13.2.2. ALTER USER. . . . . . . . .