How to query just some part of a database? #998
-
|
I dont want to scan all tables. I just want to query and analyze one or two schemas on my oracle database? How should i proceeed? |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments 1 reply
-
|
The most reliable way to do this is to create a database user that only has access to those specific tables/schemas. The other mechanism would be to override the run sql tool to reject queries against tables that aren't in an allowed list. Beyond those 2, any other mechanism is simply a "suggestion" to the LLM and the user can maliciously prompt engineer their way to querying unapproved tables. |
Beta Was this translation helpful? Give feedback.
-
|
This may be a solution for running the queries but when i ask a question, the system scans tables through the objects (oracle db) as all_tables, all_columns,dba_tables etc. So it scans every table on database, i want to narrow these if that's possible. |
Beta Was this translation helpful? Give feedback.
-
|
It was available in vanna v1 , we use to either vn.documentation only schema which is required or thru vn.train only those tables. This way we could have restricted llm to use only specific tables |
Beta Was this translation helpful? Give feedback.
The most reliable way to do this is to create a database user that only has access to those specific tables/schemas.
The other mechanism would be to override the run sql tool to reject queries against tables that aren't in an allowed list.
Beyond those 2, any other mechanism is simply a "suggestion" to the LLM and the user can maliciously prompt engineer their way to querying unapproved tables.