Unable to retrieve list of table names???

[Migration User]

Error is below, any help is appreciated.

Unable to retrieve the list of table names: Invalid object name 'information_schema.tables'.

 

The user is able to log in to the database, but gets an error trying to get the list of table names.  The credentials are correct.

 

[Migration User]

INFORMATION_SCHEMA.TABLES is specific to SQL Server.  I presume you're talking about the Symantec DLP database here, since that's the group you're posting this under.  Since that only runs on Oracle, this won't work.

Try "select table_name from user_tables;" when logged into the database as the protect user.

~Keith

[Migration User]

this is an error that comes up while performing a SQL DB scan.  

[Migration User]

The context of the problem obviously helps here.  I'd verify the privileges assigned to the user you are scanning with.  Probably does not have access to the information_schema table in the first place, which is causing the problem.  Or it needs to be qualified in such a way that's not set up in the sql scanning configuration file (which is modifiable, by the way, so you can "customize" that query used to select the tables that should be scanned).

I'm guessing it's the permissions though.  Log in through SQL with that user and try to select on that table to verify.

[Migration User]

it's not permissions since the user has confrmed that he can log in to SQL.  What you need to do is go in to the discover server that the scan is configured to run on and go to c:\vontu\protect\logs and edit the sqldatabasecrawler.properties file.  At the end of Microsoft SQL Server section you will see information_schema.tables in lower case. Change that to upper case, and restart the vontu monitor service on the same box. 

Go restart your scan, problem resolved.  Everyone should notate this as being a critical part of the installation process of SQL DB scanners because even with the right credentials it will still fail. 

 

Good luck.