----- Original Message ----- From: "Mark C. Stafford" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Monday, September 06, 2004 6:42 PM Subject: Without grant option?
> 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 > */ > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]