Magento uses two main tables
admin_rules = This tables store which resource are “allow” and “deny” for any role
For each role, for all resources in adminhtml -> acl -> resources there is an entry in this table.
Or if a role has access to all resource then in resource_id we can “all”
admin_role = This table store the role name, role id for each role defined