Replication of CURRENT-opracowanie

Nasza ocena:

3
Wyświetleń: 567
Komentarze: 0
Notatek.pl

Pobierz ten dokument za darmo

Podgląd dokumentu
Replication of CURRENT-opracowanie - strona 1

Fragment notatki:

Replication of CURRENT_USER()
The following statements support use of the CURRENT_USER() [1287] function to 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 PROCEDURE
• CREATE TRIGGER
• CREATE EVENT
• CREATE VIEW
• ALTER EVENT
• ALTER VIEW
• SET PASSWORD
When CURRENT_USER() [1287] or CURRENT_USER [1287] is used as the definer in any of the
statements CREATE FUNCTION, CREATE PROCEDURE, 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 CURRENT_USER [1287] is also
expanded prior to being written to the binary log when used in DROP USER, RENAME USER, GRANT,
REVOKE, or ALTER EVENT.
... zobacz całą notatkę

Komentarze użytkowników (0)

Zaloguj się, aby dodać komentarz