MySQL Forums
Forum List  »  Stored Procedures

Re: Grant Execute on selected procedures
Posted by: Jay Alverson
Date: December 05, 2008 07:39PM

I believe so. From the help file, section 12.5.1.3. GRANT Syntax...

Routine level 

The CREATE ROUTINE, ALTER ROUTINE, EXECUTE, and GRANT privileges apply to
stored routines (functions and procedures). They can be granted at the global
and database levels. Also, except for CREATE ROUTINE, these privileges can be
granted at the routine level for individual routines and are stored in the
mysql.procs_priv table. 

GRANT CREATE ROUTINE ON mydb.* TO 'someuser'@'somehost';
GRANT EXECUTE ON PROCEDURE mydb.myproc TO 'someuser'@'somehost';

The object_type clause was added in MySQL 5.0.6. It should be specified as
TABLE, FUNCTION, or PROCEDURE when the following object is a table, a stored
function, or a stored procedure. 

Warning
If you specify ON * and you have not selected a default database, the privileges granted are global.


>

Thanks, Jay

Options: ReplyQuote


Subject
Views
Written By
Posted
16099
December 05, 2008 04:18AM
Re: Grant Execute on selected procedures
41636
December 05, 2008 07:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.