Bug #6367 new SQL commando show stored procedures / show functions
Submitted: 1 Nov 2004 16:44 Modified: 1 Apr 2005 19:12
Reporter: Michael Kofler Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0 OS:Any (all)
Assigned to: CPU Architecture:Any

[1 Nov 2004 16:44] Michael Kofler 
Description:
the only way to find out which stored procedures or functions are available is to query the mysql.proc table; 

however, a user with full privileges to a certain database might have no privileges to read mysql.proc; thus, it is impossible to find out which SPs/functions are available

currently, it is impossible to administrate SPs without having root privileges

How to repeat:
-

Suggested fix:
new SQL commands

SHOW STORED PROCEDURES [LIKE pattern]
SHOW FUNCTIONS [LIKE pattern]

which apply to the current database
[16 Mar 2005 15:20] Michael Kofler 
can be closed

SHOW FUNCTION STATUS
SHOW PROCEDURE STATUS

provide all information needed
[1 Apr 2005 19:12] Peter Gulutzan 
Closed due to last comment: "can be closed". And since the original request, we have added support for "select ... from information_schema.routines".