The search index could not be updated. The site is misconfigured. Contact an administrator. SQLSTATE[42000]: Syntax error or access violation: 1064 unknown table 'tiki_main_67970848c9392' in delete request
I think this is possible if you turn off 'display modules to all groups always' from Admin->General and then go into administration of modules and for each module assign which groups you want to be able to see the module.