CiviCRM Community Forums (archive)

At first glance this question may look completely moronic, please bear with me...

I'm implementing CiviCRM ACL for the first time manually - we used to use Drupal Organic Groups and the OG sync component.

I have a whole lot of roles left over from the OG sync that I would like to get rid of in one fell swoop using a MySQL client.

I expect to find a table called civicrm_acl_role

But there isn't one in the database.

Everything is working well - and when I delete manually there are no complaints. I can also add acl roles, assign them and all is well.

In the acl table I can see civicrm_acl_role listed as an entity table

Why can I not see the table?

I should add that I am fairly competent with SQL and can clients comfortably.

the acl role is stored under the civicrm_option_group / civicrm_option_value set of tables

search for a group with name acl_role (typically id == 8 or so)

lobo