On Fri, 16 Jan 2004, Jough P wrote: > Greetings all, I'm trying to grant a user the file privilege and am > getting error messages. Here's my SQL statement > > mysql> GRANT file ON bs.table1 TO [EMAIL PROTECTED] IDENTIFIED BY > 'password123'; > > It gets the following error: > > ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual > which privileges can be used.
the FILE privilege is a global privilege, and as such needs to be in the *.* context. It does not work on a db-level. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]