**Data:**

1. Transaction table with region field (Oracle database-Only read access).
2. Users table in excel with region field. (I can add this table in secondary database)

**LDAP Authentication** is used.

Using views(**raw SQL query** is used), I am showing aggregated data of transaction table.

All users are seeing same data, as there is no filter on the region.

Now, I want to aggregate only those records which login user's region belongs to.

How can these implemented?

**My approach:**

* Create region model
* Implement a Foreign Key with transaction tables(Is it possible?)

What is best approach to this scenario?

Please explain clearly in steps.

**NOTE:** I have solved my problem. Please look my answer. Is there any drawbacks of my approach? (New best approach is appreciated)