On Mon, 12 Jan 2004, Viktor wrote: > Hello mysql, > > Table-level privileges do not work at all... (on Windows)
Works fine for me: 4.1.1a-alpha-max-nt:tmp >GRANT SELECT ON tmp.tmp TO [EMAIL PROTECTED] IDENTIFIED BY 'aaa'; Query OK, 0 rows affected (0.18 sec) 4.1.1a-alpha-max-nt:tmp >\q Bye C:\mysql\4.1-tree\bin>.\mysql -u tmp -p -P 3308 Enter password: *** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.1.1a-alpha-max-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. 4.1.1a-alpha-max-nt:(none) >SELECT * FROM tmp.tmp; +------+ | a | +------+ | 1 | +------+ 1 row in set (0.42 sec) 4.1.1a-alpha-max-nt:(none) >SELECT * FROM tmp.meep; ERROR 1142 (42000): select command denied to user: 'tmp'@'localhost' for table 'meep' 4.1.1a-alpha-max-nt:(none) > cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]