VIEW privileges must be granted in to the database user account in MySQL if the webform is to be adopted

Not having VIEW privilege is another cause of the mysterious "Data module was unable to adopt view...." error, besides the table prefix issue.