Hi Jerry,
You can specify the USE ROLE statements as a Connection Hook:
http://confluence.dbvis.com/display/UG95/Executing+SQL+at+Connect+and+Disconnect
The USE DATABASE statement shouldn't be needed because DbVisualizer switches between databases (catalogs) internally based on e.g. the selected database in an SQL Commander tab or the position of an object in the tree.
Best Regards,
Hans
Jerry Yu
I was able to connect to our Snowflake database using Python, but have trouble doing it in DBVZ. The commands I entered in Python that lets me see the full database is below, but I have trouble finding the place in DBVZ to enter that.
I was able to connect to our database in DBVZ, but cannot see the other DBs that Python sees. Any idea where I can specify role in DBVZ?