Fixed in CVS.

Actually no. The SQL script is automatically created from separate 
scripts for the different modules, and some modules have 
MySQL-specific scripts, while others don't.

But we already removed all GRANT statements completely in CVS HEAD, 
which will be Groupware 1.1, we just need to merge this to the stable 
version.

I placed a high priority on this ticket merely because of the 
permissions involved when using the included sql creation script.  If 
you feel the priority is incorrect, please handle accordingly.



Just a quick note to let you know about a very minor inconsistency in 
the installation script for MySQL located in



/scripts/sql/groupware.mysql.sql



At the end of the installation script you likely meant to append the 
'@localhost' to the userid during the GRANT statements for tasks and 
memos, lines 233 and 252 respectively:



233: GRANT SELECT, INSERT, UPDATE, DELETE ON nag_tasks TO horde;

252: GRANT SELECT, INSERT, UPDATE, DELETE ON mnemo_memos TO horde;



... should likely be ...



233: GRANT SELECT, INSERT, UPDATE, DELETE ON nag_tasks TO horde@localhost;

252: GRANT SELECT, INSERT, UPDATE, DELETE ON mnemo_memos TO horde@localhost;



During the installation process, a second (unnecessary) entry is made 
in the mysql.user table for the 'horde' user and the permissions in 
the mysql.tables_priv table are open for the two tables as well.  One 
account ('horde'@'localhost') can be used only when connecting from 
the localhost whereas the other ('horde'@'%') can be used to connect 
from any other host.



Best regards,

Todd