Triggers and events are not invoked automatically by the server.
(a) True
(b) False
I had been asked this question in an interview.
My doubt is from Internal Security: Preventing Unauthorized Filesystem Access topic in portion Access Control and Security of MySQL
(a) True
(b) False
I had been asked this question in an interview.
My doubt is from Internal Security: Preventing Unauthorized Filesystem Access topic in portion Access Control and Security of MySQL
Right choice is (b) False
Explanation: The triggers and events are invoked automatically by the server, so the concept of invoking user is not applied. Thus, they have no SQL SECURITY characteristic and always execute with definer privileges.