https://community.splunk.com/t5/Splunk-Search/db-lookup-not-found/m-p/38057#M8622 <P>Hi,</P> <P>I just added a db lookup (via db connect), and when I try to use it via a search, I get a "lookup table does not exist" message. It's there, and when I execute the sql via a dbquery, it returns data. Is there another required step? </P> Wed, 20 Feb 2013 18:22:14 GMT a212830 2013-02-20T18:22:14Z https://community.splunk.com/t5/Splunk-Search/db-lookup-not-found/m-p/38057#M8622 <P>Hi,</P> <P>I just added a db lookup (via db connect), and when I try to use it via a search, I get a "lookup table does not exist" message. It's there, and when I execute the sql via a dbquery, it returns data. Is there another required step? </P> Wed, 20 Feb 2013 18:22:14 GMT https://community.splunk.com/t5/Splunk-Search/db-lookup-not-found/m-p/38057#M8622 a212830 2013-02-20T18:22:14Z https://community.splunk.com/t5/Splunk-Search/db-lookup-not-found/m-p/38058#M8623 <P>Not sure if you are using the same user that created the db lookup to make the search. I was able to get the lookup table when I used the same user. However, when I use a user with fewer capabilities, I got the same problem.</P> <P>I added the dbx_user role to the user who has to search with this db lookup and it worked. However, it will expose the "External Database" section to that user. I'm still finding ways to avoid this while letting that user use the db lookup.</P> Tue, 10 Jun 2014 01:25:26 GMT https://community.splunk.com/t5/Splunk-Search/db-lookup-not-found/m-p/38058#M8623 chanst2 2014-06-10T01:25:26Z