I'm trying to use externally identified users on a Win2000 client against both a Win2000 and a HP-UX server. Is there any way to allow just (client) users from a certain domain to connect to the database by entering SQLPLUS /@tns_string?
Not to my knowledge. External OS authentication is meant to identify those users who have authenticated to the server where the database resides. It is not meant to identify those users who have authenticated on other platforms.
What you may want to investigate is the Oracle Connection Manager. Supposedly, you can authenticate to this central server and then connect to all the databases you are authorized on. I've never used Connection Manager myself, but it sounds likes it fits your bill!
For More Information
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical Oracle questions--or help out your peers by answering them--in our live discussion forums.
- Ask the Experts yourself: Our Oracle gurus are waiting to answer your toughest questions.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.