O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Access control

All stored programs (procedures, functions, triggers, and events) and views have a DEFINER. If the DEFINER is not specified, the user who creates the object will be chosen as DEFINER.

Stored routines (procedures and functions) and views  have an SQL SECURITY characteristic with a value of DEFINER or INVOKER to specify whether the object executes in the definer or invoker context. Triggers and events have no SQL SECURITY characteristic and always execute in the definer context. The server invokes these objects automatically as necessary, so there is no invoking user.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required