The following table defines the meanings of the SQL SECURITY options.
Privilege Option | Description |
---|---|
CREATOR | Assign the privileges of the creator of the procedure regardless of its containing database or user. |
DEFINER | Assign the privileges of the definer of the procedure. This is the default. |
INVOKER | Assign the privileges possessed by the user at the top of the current execution stack. |
OWNER | Assign the privileges owned by the owner of the procedure, which are the privileges possessed by its containing database or user. |