Re: Grant Execute on selected procedures
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
Subject
Views
Written By
Posted
16074
December 05, 2008 04:18AM
Re: Grant Execute on selected procedures
41616
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.