Restricting search using lookup table

[nandm]

I have a scenario where I need to restrict 100+ users within an index to their respective departments. I created an app with views where the dropdown field is populated using a lookup table for departments and this works great based on the logged in user/role. However the user is still able to access the entire index using the search app available globally.

Is there a way to use 'Restrict search terms' field within the role to specify a lookup table and restrict the user to specific departments so the implied search string would inherit something like :

department="1234" OR department="4567" (where the value is a lookup field.)

I know it can be achieved by creating several roles and assigning them individually, however I am trying to automate this so that a single role caters for all the users.

[dart]

My suggestion would be to write a script against the SDK to do this. Check out the docs on access and roles http://docs.splunk.com/Documentation/Splunk/latest/RESTAPI/RESTaccess