File_priv syntax?

2004-01-16 Thread Jough P 
Greetings all, I'm trying to grant a user the file privelege 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.

Thanks tons!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: File_priv syntax?

2004-01-16 Thread Tobias Asplund 
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]