This CHAR(128) parameter specifies the name of the procedure to return privileges for. If proc_name is not specified, the privileges required for all procedures are returned. The default is NULL.
In the result set, if a number of privileges separated by a comma is listed for a stored procedure, then it implies that any
one of those privileges would suffice. If multiple rows are displayed for a stored procedure, then one privilege from each
row is required to execute the stored procedure.
If sp_proc_priv is invoked without proc_name, it returns privilege information for all procedures that require privileges. System procedures that do not require privileges
are not included in the results.
This procedure only lists privileges for a stored procedure that never fails the permission check for the procedure. There
may be other privileges that pass the permission check to execute the procedure under certain conditions, but those privileges
are not listed.
The following example returns the privileges required to run the sa_table_fragmentation system procedure. Since only one row
is returned, any one of the privileges in the comma separated list is sufficient to run sa_table_fragmentation.
CALL sp_proc_priv( 'sa_table_fragmentation' );
MANAGE ANY STATISTICS, MONITOR
The following example returns the privileges for the sa_install_feature system procedure. Since multiple rows are returned,
one privilege from each row is required to run sa_install_feature.