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"...
I have across some strange issue. A USP was created couple of days ago. When I'm doing "SHOW PROCEDURE" to this USP, it shows to contain a REPLACE VIEW definition in it's code but it actually contains 3 Update statements. However the batch calling it seems to be running perfectly fine but not sure how it's ending up showing wrong code.
Any hint/light on this issue is very much appreciated.