List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:August 12 2005 9:59am
Subject:Re: GRANT EXECUTE in MySQL 4.1
View as plain text  
> > For some reason, GRANT EXECUTE is possible on the global
> > level, but not on the database level:
> > "Incorrect usage of DB GRANT and GLOBAL PRIVILEGES"
> >
> > Has anyone got any idea what EXECUTE should do on a global
> > level in MySQL 4.1?
>
> Martin,
>
> EXECUTE is specifically for stored procedures.. Whilst the privilege is
> available in >= 4.0.2, it has no effect at all until 5.0.something. This
is
> all documented in the "Privileges provided by MySQL" manual page I
believe..

Right. I thought it was strange :-)

> EXECUTE on a GLOBAL level would, of course, allow the grantee to call any
> stored procedure.

Figures.

Thanks.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Thread
GRANT EXECUTE in MySQL 4.1Martijn Tonies12 Aug
  • RE: GRANT EXECUTE in MySQL 4.1Mark Leith12 Aug
    • Re: GRANT EXECUTE in MySQL 4.1Martijn Tonies12 Aug
  • Re: GRANT EXECUTE in MySQL 4.1Gleb Paharenko12 Aug