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?