db lookup not found

[a212830]

Hi,

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?

[chanst2]

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.

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.