Print Thread
Is there option to save Schema along with the user/pwd Connections
#64511 03/15/23 12:38 PM
Joined: Sep 2003
Posts: 40
S
sakalk Offline OP
Member
OP Offline
Member
S
Joined: Sep 2003
Posts: 40
Hi,
It Seems when I am having a PLSQLD running and internally if i login using a User and set a Schema, if i switch logins it seem to retain the last entered schema on a connection, which is perfect.

However , when I close PLSQLD and re-open, then when i make a connection to previously saved user/pwd connection, the last schema gets lost. Is there a setting to enable saving this with the connections please?

Thanks
SaKa

Last edited by sakalk; 03/15/23 12:39 PM.
Re: Is there option to save Schema along with the user/pwd Connections
sakalk #64514 03/16/23 09:48 AM
Joined: Aug 1999
Posts: 22,201
Member
Offline
Member
Joined: Aug 1999
Posts: 22,201
There is currently no option for this. I have added this to the list of enhancement requests.

If you always use the same schema for a specific connection, you can execute the "alter session set current_schema" command in the initialization script of the connection definition.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.050s Queries: 15 (0.031s) Memory: 2.4954 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-04-23 16:47:29 UTC
Valid HTML 5 and Valid CSS