Print Thread
Command line parameters for username and dbname
#62573 05/19/21 06:46 PM
Joined: Jan 2006
Posts: 162
Russian, SPB
Starina Offline OP
Member
OP Offline
Member
Joined: Jan 2006
Posts: 162
Russian, SPB
How can I start the IDE with predefined username and database name. Password must be empty. Which command line parameters should be?


rrProject plugin developer (GitHub)
Donate
Re: Command line parameters for username and dbname
Starina #62575 05/20/21 09:33 AM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
You can use the userid parameter. For example:

plsqldev.exe userid=scott@chicago


Marco Kalter
Allround Automations
Re: Command line parameters for username and dbname
Starina #62577 05/21/21 05:52 AM
Joined: Jan 2006
Posts: 162
Russian, SPB
Starina Offline OP
Member
OP Offline
Member
Joined: Jan 2006
Posts: 162
Russian, SPB
When I pass parameter as plsqldev.exe userid=scott@chicago, I get the error ORA-01005: null password given; logon denied.

This is very annoying.

Last edited by Starina; 05/21/21 06:18 AM.

rrProject plugin developer (GitHub)
Donate
Re: Command line parameters for username and dbname
Starina #62578 05/21/21 08:48 AM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
There is currently no option to set a default username and password.


Marco Kalter
Allround Automations
Re: Command line parameters for username and dbname
Starina #62665 08/04/21 01:15 PM
Joined: Aug 2021
Posts: 1
A
Member
Offline
Member
A
Joined: Aug 2021
Posts: 1
Hi, is it possible to make a connection from command line as sysdba?

Re: Command line parameters for username and dbname
Starina #62668 08/05/21 08:53 AM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
Yes, but you will have to enclose the parameter value in double quotes, so that the spaces are parsed correctly. For example:

plsqldev.exe userid="sys/manager@chicago as sysdba"


Marco Kalter
Allround Automations
Re: Command line parameters for username and dbname
Starina #62676 08/07/21 03:44 PM
Joined: Sep 2003
Posts: 387
London, UK
Member
Offline
Member
Joined: Sep 2003
Posts: 387
London, UK
To log in as a specific user, you could set up the user in Connections with no password, and check "Connect on startup". Then starting PL/SQL Developer prompts for login credentials on startup with user and database service pre-filled. (Not exactly what you are after, but might be close.)


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.038s Queries: 14 (0.011s) Memory: 2.5223 MB (Peak: 3.0405 MB) Data Comp: Off Server Time: 2024-05-11 13:28:32 UTC
Valid HTML 5 and Valid CSS