asked, on the list, how he could reduce the buffer cache as much as possible but still have a responsive system. Ann has given her permission for this posting to be documented formally as part of the from which it then knows where to find the pointer pages, amongst other things, for the system and user tables within the database. As soon as the application accesses the database and begins a transaction cache reads for every physical read. Of the 529 updated pages - and these are system as well as user pages - 526 have been written back to the physical discs but three still remain in cache, as yet

mechanism to Chapter 4. Using generators to create unique row IDs 12 make this work safely in multi-user/multi-transaction environments, JUST DON’T DO IT! 4.4. Generators for IDs or auto-increment fields inserted. You could grab the generator value from the client side after the Insert, but in multi-user environments you cannot be really sure that what you get is your own row’s ID (because of the transaction transfer by labeling it with a generated value. This greatly helps tracking down problems with interfaces between two systems (and, unlike most of the following, this does work safely and exactly). 5

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

desejável o uso de uma ferramenta dedicada. Ferramentas de elaboração de XML geralmente possuem interfaces gráficas que fazem as tags sobressaírem muito bem (e algumas vezes irritantemente); muitas permitirão também o que acontece com múltiplos caracteres espaço em branco, porque certos editores XML podem user certos truques para preservá-los. Elementos que usamos freqüentemente Esta seção discute os elementos

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 540 11.7. CURRENT_USER. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 551 11.24. USER . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 569 13.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. . . . . . . . .