•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 391,957 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,894 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser:
Views: 1158 | Replies: 6 | Solved
 |
•
•
Join Date: Feb 2008
Posts: 6
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Help needed! Oracle settings for integrated security Hi all,
I am currently doing an application using MS Access 97 as front-end GUI, connecting to a back-end Oracle server. The Oracle server version is 9.x.
Now I wanna use integrated security so that I won't need to enter the username/password every time I start my application. The problem now is that the Oracle server is in a unix server, and I don't know
1) How to configure Oracle so that it accepts integrated security,
2) How to connect to Oracle from the my application.
I have been doing research on this for long but without solutions.
Anyone, any suggestions?
Thank you very much.
Regards,
reuifdjk
I am currently doing an application using MS Access 97 as front-end GUI, connecting to a back-end Oracle server. The Oracle server version is 9.x.
Now I wanna use integrated security so that I won't need to enter the username/password every time I start my application. The problem now is that the Oracle server is in a unix server, and I don't know
1) How to configure Oracle so that it accepts integrated security,
2) How to connect to Oracle from the my application.
I have been doing research on this for long but without solutions.
Anyone, any suggestions?
Thank you very much.
Regards,
reuifdjk
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,213
Reputation:
Rep Power: 4
Solved Threads: 78
•
•
Join Date: Nov 2007
Posts: 51
Reputation:
Rep Power: 1
Solved Threads: 9
Junior Poster in Training
You can't use Windows security, you'll have to hardcode the user name and password somewhere.
Nige
Nige
•
•
Join Date: Feb 2008
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by Nige Ridd 
You can't use Windows security, you'll have to hardcode the user name and password somewhere.
Nige
What do you mean by Windows security?
What I wanna know is how to use the integrated security feature of Oracle. And the Oracle is in a unix server, the application is in a windows os.
Any more suggestions?
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,213
Reputation:
Rep Power: 4
Solved Threads: 78
Are you able to connect to the database from windows PC ?
Share your Knowledge.
•
•
Join Date: Feb 2008
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Thanx for all the help.
I have configured how to do this following the steps:
1. Set OS_AUTHENT_PREFIX:
SQL> ALTER SYSTEM SET OS_AUTHENT_PREFIX = "" SCOPE=SPFILE;
2. Set REMOTE_OS_AUTHENT:
SQL> ALTER SYSTEM SET REMOTE_OS_AUTHENT = TRUE SCOPE=SPFILE;
3. For Windows servers, set in the "%ORACLE_HOME%\network\admin\sqlnet.ora" file:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
4. Restart database.
5. Create the users.
SQL> CREATE USER xx INDENTIFIED EXTERNALLY;
I have configured how to do this following the steps:
1. Set OS_AUTHENT_PREFIX:
SQL> ALTER SYSTEM SET OS_AUTHENT_PREFIX = "" SCOPE=SPFILE;
2. Set REMOTE_OS_AUTHENT:
SQL> ALTER SYSTEM SET REMOTE_OS_AUTHENT = TRUE SCOPE=SPFILE;
3. For Windows servers, set in the "%ORACLE_HOME%\network\admin\sqlnet.ora" file:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
4. Restart database.
5. Create the users.
SQL> CREATE USER xx INDENTIFIED EXTERNALLY;
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
Linear Mode
•
•
•
•
advice antivirus apple botnet browser business crime daniweb data data protection development email encryption firefox forensic fraud google hacking help id theft information internet kaspersky linux malware mcafee michael knight microsoft mobile news phishing privacy report research satnav search security software spam spyware survey symbian terrorism trends trojan virus vista web windows worm
- Simple ASP.Net Login Page (Using VB.Net) (ASP.NET)
Other Threads in the Oracle Forum
- Previous Thread: Oracle EXP and INP
- Next Thread: oracle9i operating system audit file location
