On Mon, 2003-03-10 at 19:39, Fred Bauder wrote:
Which mysql privileges should wikiuser have?
See buildusers.sql in the maintenance subdirectory.
How about sysops?
SQL query access for sysops goes through the 'wikisql' user. Should be in buildusers.sql as well... Basically, read-only access to all tables except for the password and e-mail fields in the user table.
Developers?
SQL query access for developers goes through wikiuser, same as the wiki interface.
Note that the user 'wikiadmin' is used only by the maintenance scripts (createdb.php, rebuildLinks.php etc) and, optionally, manual maintenance.
-- brion vibber (brion @ pobox.com)