On Freitag, 27. Juni 2008, Alex Le Bek wrote: > Hi, > > I wanted to make my smw site more secure with only RW access on the db web > user - so I was surprised to get this error - > > "SMW::getCategoryTable". MySQL returned error "1142: DROP command denied to > user '********' for table 'smw_newcats' (webhost-db:3307)". > > SMW_SQLStore creates temporary tables (and then drops them?) - anyway does > this mean that web access users have drop (and delete?) privileges?
No, it is enough to have CREATE TEMPORARY and DROP TEMPORARY privileges (this was changed recently -- if its not the case in SMW 1.1, it will be this way in SMW 1.2). You can also disable subcategory/subproperty reasoning to avoid any temp tables from being used (see subcategorydepth and subpropertydepth settings as defined in SMW_Settings.php). Markus > > Alex -- Markus Krötzsch Semantic MediaWiki http://semantic-mediawiki.org http://korrekt.org [EMAIL PROTECTED]
signature.asc
Description: This is a digitally signed message part.
------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php
_______________________________________________ Semediawiki-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
