Re: is there a way to change OS-authentication from within Oracle rather than change all logins

On 3 Aug 2004 10:18:08 -0500, colin_lyse_at_yahsd.com (colin_lyse) wrote:

>
>using Oracle 9i on Win/2003 server
>
>We have over 50 accounts using OS-authentication on NT to access Oracle. they
>use Domain and username to get into Oracle.
>
>We have migrated to Active Directory and our prior domain was deleted and a
>new one was created. Problem is that all the accounts are of the type
>OPS$domian_name\userid. Since the old domian does not exist anymore the
>account is not authenticated and we get the error ORA-01017 invalid
>username/password; login denied.
>
>We don't want to create 50 new accounts and get deleted the old 50 and then
>change all the login scripts etc, espically since the pc with are spread all
>over the state many in out of the way rural areas and we would literally have
>to drive around to each one.
>
>is there a way inside of Oracle to somehow map these accounts so that they do
>have access? maybe not allow remote access and have them pass the old login
>directly?

There isn't. Apparently you didn't verify the ramifications of the change prior to executing it.

--
Sybrand Bakker, Senior Oracle DBA