See:
https://answers.splunk.com/answers/230465/splunk-db-connect-why-am-i-getting-error-no-schema.html
"In DB, there are schemas available and each schema has different tables. So in the DB you need to provide schema access & table access to user from which splunk is trying to fetch data."
... View more