topic How to restrict a user's search based on a lookup table? in Splunk Search

How to restrict a user's search based on a lookup table?

bruceclarke — Fri, 08 Aug 2014 13:37:12 GMT

Hi all,

I'm developing an app for use across different teams at my company. We have certain security restrictions about what logs each team can see. So, team A might be permissioned to see every log statement, while team B will only be allowed to see logs related to a certain server.

I have a lookup table that determines which servers each employee is permissioned to and I'd like to restrict their searches based on this. Does anyone know of a way I can do this?

Please note that all of these logs are going to the same index. They are all the same type of log, just a different server.

Thanks!

Re: How to restrict a user's search based on a lookup table?

somesoni2 — Fri, 08 Aug 2014 14:00:49 GMT

Create a macro to get the filter to be used for host based on your lookup and then use this macro as search filter in the team's role definition.

Re: How to restrict a user's search based on a lookup table?

alacercogitatus — Fri, 08 Aug 2014 14:14:32 GMT

In authorize.conf, there is a setting: srchFilter = . This can also be done via the GUI Admin Manager. It takes a string of search to restrict searches. I did a preliminary test, and it worked. In that field, try this:

|rest /services/authentication/current-context | table username | lookup user_auths.csv user AS username OUTPUT host | table host | format "" "(" "OR" ")" "" ""

Replace "user_auths.csv" with your lookup name or filename. Update the "user" field to be whatever is listed in that csv.

Re: How to restrict a user's search based on a lookup table?

strive — Fri, 08 Aug 2014 14:20:11 GMT

More information on search filters is here http://docs.splunk.com/Documentation/Splunk/6.1.2/Security/Addandeditroles#Search_filter_format