> > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]