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.
Many thanks Dieter
PS: The ranking system on this forum must be seriously faulty to show you as a "Junior Contributor"...