> -----Original Message----- > From: Martijn Tonies [mailto:[EMAIL PROTECTED] > Sent: 12 August 2005 09:40 > To: mysql@lists.mysql.com > Subject: GRANT EXECUTE in MySQL 4.1 > > Hi there, > > 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? > > 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
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.. EXECUTE on a GLOBAL level would, of course, allow the grantee to call any stored procedure. HTH Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk http://leithal.cool-tools.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]