Details
-
Type:
Technical task
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.3
-
Fix Version/s: None
-
Component/s: Stored routines
-
Labels:
Description
MariaDB uses this SQL syntax to tell if a stored routine should be invoked with the definer or the invoker security:
<rights clause> ::= SQL SECURITY INVOKER | SQL SECURITY DEFINER
|
Oracle uses a different syntax for the same thing:
<invoker_rights_clause> ::= AUTHID CURRENT_USER | AUTHID DEFINER
|
When running with sql_mode=ORACLE, MariaDB will understand Oracle syntax.