# Whitelisting not working as expected

**URL:** <https://discourse.pi-hole.net/t/whitelisting-not-working-as-expected/37921>\
**Category:** Help\
**Created:** [September 2, 2020, 1:14pm UTC](https://discourse.pi-hole.net/t/whitelisting-not-working-as-expected/37921 "2020-09-02T13:14:46Z")\
**Posts on this page:** 1\
**Showing post:** 11

<div class="post-metadata">

**Author:** ![yubiuser](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/yubiuser/32/12100_2.png) [@yubiuser](https://discourse.pi-hole.net/u/yubiuser)\
**Post date:** [September 3, 2020, 7:33pm UTC](https://discourse.pi-hole.net/t/whitelisting-not-working-as-expected/37921/11 "2020-09-03T19:33:53Z")

</div>

> [@BinaryDichotomy](#):
>
> I know for MSFT Sql Server a quick hack would be putting a trigger on a table (not ideal, but it would work)...is this possible for the db PH uses?

Yes.  
For an inspiration:

> [@Group Management question](https://discourse.pi-hole.net/t/group-management-question/32062/3):
>
> You could add a trigger into your database, automatically adding more/other groups on creation of new clients. Note that, however, this change may be in conflict with future Pi-hole updates so you'll have to make sure to reset your local changes before updating (it will just not work, otherwise, there is no other harm involved here). The relevant triggers you'd want to look at are: [https://github.com/pi-hole/pi-hole/blob/4d25f695267590b61a4061f9bb43448005d99b85/advanced/Templates/gravity.db.sq…](https://github.com/pi-hole/pi-hole/blob/4d25f695267590b61a4061f9bb43448005d99b85/advanced/Templates/gravity.db.sql#L148-L161)

---

_[View the full topic](https://discourse.pi-hole.net/t/whitelisting-not-working-as-expected/37921)._