[ic] New catelogue with MySQL problems

[Stefan Hornburg]

Greg Cope <gjjc@rubberplant.freeserve.co.uk> writes:


[...]

> 
> Yup.
> 
> But I solved the problem.
> 
> MySQL permissions.
> 
> I operate a quite restrictive policy - i.e I gave the interchange user
> too few permissions - Index and Delete privileges where needed - a quick
> grant INDEX, DELETE ..... on ... fixed it.
> 
> Sounds easy ... but it raises onther question:
> 
> Why does interchange need "Creation style" priveleges such as index,
> delete and create - would it be possible to remove these and have them
> run at makecat time (under an admins privelege), so that interchange
> cats run under the least privileges  ?

I think it doesn't need them with the following setup:

* create and fill tables manually
* add "NoImportExternal Yes" to catalog.cfg

Ciao
        Racke

-- 
LinuXia Systems && Cobolt NetServices, eCommerce and more
Shop- und Datenbanklösungen mit MiniVend, Firewalls auf Debian-Basis
http://www.linuxia.de - http://www.cobolt.net
--> Junior Officer of the MiniVend/Interchange Bug Patrol <---