89485

89485



Replication of current_user()

The foliowing statements support use of the CURRENTJJSER () [1287] functionto take the

place of the name of (and, possibly, the host for) an affected user or a definer; in such cases,

CURRENT_USER () [1287] is expanded where and as needed:

•DROP USER •RENAME USER •GRANT • REVOKE

•CREATE FUNCTION •CREATE PROCEDURĘ •CREATE TRIGGER •CREATE EVENT •CREATE VIEW •ALTER EVENT •ALTER VIEW •SET PASSWORD

When CURRENT_USER () [1287] or CURRENTJJSER [1287] is used as the definer in any of the

statements CREATE FUNCTION, CREATE PROCEDURĘ, CREATE TRIGGER, CREATE EVENT, CREATE

VIEW, or ALTER VIEW when binary logging is enabled, the function reference is expanded before it

is written to the binary log, so that the statement refers to the same user on both the master and the

slave when the statement is replicated. CURRENT_USER () [1287] or

CURRENTJJSER [1287]isalso

expanded prior to being written to the binary log when used in DROP USER, RENAME USER, GRANT,

REVOKE, or ALTER EVENT.



Wyszukiwarka

Podobne podstrony:
Replication and auto_increment Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID ()
Replication and limit Statement-based replication of LIMIT clauses in DELETE, UPDATE, and INSERT ...
Replication Features and Issues The following sections provide information about what is supported a
Replication Implementation Replication is based on the master sen/er keeping track of all changes to
Replication of Columns Having Different Data Types Corresponding columns on the master s and the sla
Topie 1, DESCRIBE THE OPERATION OF DATA NETWORKS (75 ąuestions)Section 1: Describe the purpose and f
9 Zastosowania rachunku różniczkowego w ekonomii Zadanie 9.7. For each of the given cost functions f
Discussion of grades on assignments must take place before two weeks have elapsed from the receipt o
wybierz x Select Windows Shell Select user interface to usekliknij na use Windows 7 explorer i masz
Replication and blackhole Tables The BLACKHOLE storage engine accepts data but discards it and does
Replication and Character Sets The following applies to replication between MySQL servers that use d
Replication and Temporary Tables The discussion in the following paragraphs does notapply
Replication and Time Zones The same system time zonę should be set for both master and slave. Otherw
Using different storage engines on master and slave. It is possible to replicate transactional table

więcej podobnych podstron