> (Fred Bauder <fredbaud@ctelco.net>):
> Which mysql privileges should wikiuser have?
>
> How about sysops?
>
> Developers?
The maintenance directory has a script "buildusers.sql" that
grants all the needed privileges to users "wikiuser", "wikiadmin",
and "wikisql". Developer status is a function of the software and
isn't manifested as a different MySQL user.
Bascially, wikiuser can do anything but create and change the database,
and most of the normal wiki functions happen as that user. Wikisql is
a restricted user that can only select; it is used for the direct SQL
query function of Sysops to limit potential damage. Wikiadmin is not
used by the software at all, but is used by the build scripts and such.
It is meant for those with real access to the server.
--
Lee Daniel Crocker <lee@piclab.com> <
http://www.piclab.com/lee/>
"All inventions or works of authorship original to me, herein and past,
are placed irrevocably in the public domain, and may be used or modified
for any purpose, without permission, attribution, or notification."--LDC