- 3,727,639 Users
- 2,245,430 Discussions
- 7,852,905 Comments
Forum Stats
Discussions
Howdy, Stranger!
Categories
- 380.8K All Categories
- 16 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 2.3K Databases
- 685 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 32 Multilingual Engine
- 499 MySQL Community Space
- 10 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 424 SQLcl
- 69 SQL Developer Data Modeler
- 185.2K SQL & PL/SQL
- 21.1K SQL Developer
- 2.7K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.9K Development Tools
- 18 DevOps
- 3K QA/Testing
- 385 Java
- 16 Java Learning Subscription
- 14 Database Connectivity
- 72 Java Community Process
- 3 Java 25
- 14 Java APIs
- 141.2K Java Development Tools
- 14 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 18 Java SE
- 13.8K Java Security
- 4 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 157 LiveLabs
- 36 Workshops
- 11 Software
- 5 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 4 Deutsche Oracle Community
- 17 Español
- 1.9K Japanese
- 4 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