I'm looking for a select statement which gives me list of available databases from a Vertica database based on user login credentials.
The following URL contains information regarding the system table "databases". It provides information about the databases in current HP Vertica installation.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.