> Sure, simply write two grants: > > GRANT SELECT, INSERT, UPDATE > ON test.* TO 'jdoe'@'192.168.%' WITH GRANT OPTION; > > GRANT DELETE > ON test.* TO 'jdoe'@'192.168.%'; > > Rhino
Thanks, Rhino...but the only difference between what you suggest and what I did seems to be where the linefeed appears in the second grant. What do you get when you run these commands after those grants? FLUSH PRIVILEGES; SHOW GRANTS FOR 'jdoe'@'192.168.%'; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]