This question is in relation to the SQL SECURITY clause which can (should be!) be specified when creating a stored procedure.
Is there any way of querying the metadata (e.g. dbc tables) to find out which stored procedures are using the various options of SQL SECURITY (?
I know you can tell by running "SHOW PROCEDURE X", and grepping for the string (or assuming the default option, DEFINER, if not found, but clearly this is cumbersome.
Solved! Go to Solution.