execute an init sql script when establishing a connection
The purpose is to be able to init some sql parameters when establishing a connection to the database.
DbVisualizer to allow this, let you enter some sql commands that will be executed when the connection is made. They call this a "connection hook". I think this is a simple and powerful way to allow this type of configuration.
This is an exemple of use :
ALTER SESSION SET CURRENT_SCHEMA = TOTO;
ALTER SESSION SET TIME_ZONE='Australia/Sydney';
Please sign in to leave a comment.
Hi,
We have already got the similar issue https://youtrack.jetbrains.com/issue/DBE-3600
Thank you.