Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 475 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Create connection without password in settings (by using wallet)
I have noticed that password has to be stored in settings even if I provide path to the wallet, during connection creation.
Is it possible to store connections in settings passwordless? Configured wallet should be enough to connect.
Answers
-
There's a checkbox in the connection dialog to "save password"? Are you unchecking that?
I don't believe simply using a wallet is sufficient. You still need to provide a username and password. Maybe I am wrong, but if I am please explain.
-
Connection cannot be created without providing a password.
If I provide a password and uncheck "Save password" box, then a password prompt appears each time I am trying to connect to DB.
-
Hi,
Thanks for your patience with this. I had a long discussion with our engineering team about the two issues you raised recently.
Based on the other thread you posted, we think there may be a misunderstanding about how you are able to connect without a password.
In the other thread, you said you are issuing:
CONNECT /@MY_DB
And your SQLNET.ORA contains:
SQLNET.AUTHENTICATION_SERVICES =(NTS)
If so, this means you are on Windows and are using OS Authentication. The password is NOT coming from the wallet. It is coming from the Windows OS. The wallet is not involved. Generally the wallet is used to secure the network connection, not for authentication of a user id (not always - there is something called "global userid" but I don't think that is the case here).
If you are connecting as the connect statement above, and you are using that same sqlnet.ora as in the other thread, the next question is, have you ever gotten this (OS Authentication) working?
And if I am wrong in my assumptions, please let us know what platform you are on, what sqlnet.ora you are using, and what other tools are able to connect without a password and how they are configured.
Hopefully we can get your issues resolved soon but it might take a bit more back and forth.
-
My answer is in the following thread:
https://community.oracle.com/tech/developers/discussion/comment/16789766/#Comment_16789766