Hi,
If it’s solid brick use Easyfix bolts from screwfix. They have a coarse thread on the bolt and are rock solid when tightened. You drill them dead size and they cut a thread in the brick, specially designed for brick. No messy resin, we’ve used these at work and I’ve used them at home...