I have a user who has permissions for a single database. The user wants to be able to add/delete users for the database. Can this be done?
Grant this use the GRANT OPTION permission. For example, if this use has control over the abc database, use either of these statements:
GRANT USAGE ON abc.* TO 'user_name'@'host_name' WITH GRANT OPTION;
or
GRANT GRANT OPTION ON abc.* TO 'user_name'@'host_name';
Thanks GNH
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
