I would prefer that 'jdoe'@'192.168.%' not be able to grant DELETE to other users...but I do want him to be able to grant SELECT. Is that possible?
- - - - - - - - - - - - - - - - - - - - GRANT SHOW DATABASES ON *.* TO 'jdoe'@'192.168.%' IDENTIFIED BY 'uhoh'; GRANT SELECT, INSERT, UPDATE ON test.* TO 'jdoe'@'192.168.%' WITH GRANT OPTION; GRANT FILE ON *.* TO 'jdoe'@'192.168.%'; GRANT DELETE ON test.* TO 'jdoe'@'192.168.%'; FLUSH PRIVILEGES; SHOW GRANTS FOR 'jdoe'@'192.168.%'; /* --Grants for [EMAIL PROTECTED] GRANT FILE, SHOW DATABASES ON *.* TO 'jdoe'@'192.168.%' IDENTIFIED BY PASSWORD '14592d223aea00a7' GRANT SELECT, INSERT, UPDATE, DELETE ON `test`.* TO 'jdoe'@'192.168.%' WITH GRANT OPTION */ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]