Just in case anyone is wondering, if you need to do a mass update on your userbank so that you can set everyone to an author, or editor etc, the table you want to use is jos_core_acl_groups_aro_map. It took me a while to find this but you just do an update where the aro_id is not equal to the super admin, or whomever else you don't want to blow away.
Good luck