----- 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]

Reply via email to