| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Using Microsoft Windows 2000 Active Directory userid to logon
Metalink doc 60634.1
but set OS_AUTHENT_PREFIX = "" and OSAUTH_PREFIX_DOMAIN = TRUE
HTH, Beth
-----Original Message-----
Sent: Friday, August 16, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L
logon
Could you point me in the right direction?
Thanks John
-----Original Message-----
Sent: August 15, 2002 5:14 PM
To: Multiple recipients of list ORACLE-L
logon to
I have it working and am pretty happy with it. It doesn't allow a user to connect to the database without entering anything, they still have to enter a / for username, but they don't have to enter a password.
One tip - for security reasons you should preface the usernames with your domain name and not OPS$ or some such nonsense.
You will occaissionally run into older products that don't support OS authentication - eg. Oracle Reports 6.0.
Beyond user ease, the other reason I like it is that I can script DBA tasks in .bat files without hardcoding username/password
HTH, Beth
-----Original Message-----
Sent: Thursday, August 15, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L
to
I have some users who use both Oracle and Microsoft SQL Server. They
like
the fact they don't have to type in a userid and password when they
logon to
SQL server, they are authenticated with their Windows logon.
They'd like the same thing when they logon to Oracle.
I seem to recall that Oracle can use the userid and password from the operating system but has anyone got this working under NT?
Thanks John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: John.Whelan_at_statcan.ca
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Aug 16 2002 - 12:43:29 CDT
 |
 |