Advertisement
Guest User

Untitled

a guest
Mar 6th, 2015
208
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. CREATE
  2. /*[DEFINER = { user | CURRENT_USER }]*/
  3. TRIGGER `mysql`.`test` BEFORE DELETE
  4. ON `mysql`.`db`
  5. FOR EACH ROW BEGIN
  6. INSERT INTO cescnet.db_monitor (DB_name,user_name,dateandtime,operation_type) VALUES (mysql.db.Db,CURRENT_USER(),NOW(),'Delete');
  7. END;|
  8.  
  9. Triggers can not be created on system tables
  10.  
  11. grant super on *.* to root@localhost
  12. grant all on *.* to root@localhost
  13.  
  14. Triggers can not be created on system tables
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement