Splunk Search

The lookup table does not exist for new user.

sanjay_shrestha
Contributor

Hi,

I created dblookup and used in a saved search as admin, which is working fine. However when I run same saved search as different user, I get following message:


The lookup table 'abc_Lookup' does not exist. It is referenced by configuration 'host::XYZ'.

Thanks,
Sanjay

Tags (1)
0 Karma
1 Solution

sanjay_shrestha
Contributor

Finally, I was able to search utilizing lookups created by Admin. Following modifications were done in ..../splunk/etc/apps/dbx/metadata/default.meta file.


[]
access = read : [ * ], write : [ admin ] -->> read [ admin] was changed to read [ * ]


### Manager ###
[manager/dblookups]
access = read : [ *  ], write : [ admin ]  -->> read [ admin] was changed to read [ * ]
export = system

View solution in original post

0 Karma

sanjay_shrestha
Contributor

Finally, I was able to search utilizing lookups created by Admin. Following modifications were done in ..../splunk/etc/apps/dbx/metadata/default.meta file.


[]
access = read : [ * ], write : [ admin ] -->> read [ admin] was changed to read [ * ]


### Manager ###
[manager/dblookups]
access = read : [ *  ], write : [ admin ]  -->> read [ admin] was changed to read [ * ]
export = system

0 Karma

yannK
Splunk Employee
Splunk Employee

you should put in local.meta to make it persistent with app upgrades

lukejadamec
Super Champion

You need to check the permissions on your lookup.

Manager > Lookups > Automatic Lookups.

Select All Apps (or the App that contains the lookup), select Permissions for that Lookup, and grant permissions to that user.

0 Karma

lukejadamec
Super Champion

I'm glad you agree. You're welcome.

0 Karma

sanjay_shrestha
Contributor

I think you are right. I do not see database lookups when logged in as new user.

0 Karma

lukejadamec
Super Champion

I'm not familiar with database lookups, but it has to be a permission problem somewhere. That is the only way one person can use it and one cannot. Have you checked the permissions on the database lookup? Can the other user see the database lookup in Manager?

0 Karma

sanjay_shrestha
Contributor

I only created Database lookups and Automatic lookups, did not create any lookup file manually.

Manager>Lookups>Lookup table files > does not have any configuration items. It is empty.

Thanks,
Sanjay

0 Karma

lukejadamec
Super Champion

I was able to recreate your problem by restricting access to the lookup table files.
Make sure Manager>Lookups>Lookup table files > your lookupfile has the correct permissions.

0 Karma

sanjay_shrestha
Contributor

I have already set those to All apps and granted permission to new user (both read and write). It was not working.

Thanks,
Sanjay

0 Karma
Get Updates on the Splunk Community!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...