12-01-13, 16:38 #1Registered User
- Join Date
- Dec 2013
Unanswered: Windows authentication from client
I am trying to get a user access from client machine to the database using windows authentication. These machines are on workgroup.
I created a local user on client machine.
CREATE USER "<CLIENTMACHINENAME>\<USERNAME>" PROFILE DEFAULT IDENTIFIED EXTERNALLY
where os_authent_prefix parameter is null.
to test this i also created a local user (db machine)
CREATE USER "<DBMACHINENAME>\<USERNAME>" PROFILE DEFAULT IDENTIFIED EXTERNALLY.
on db machine this allows me to log into database
but the same command doesnt work for client machine.
Thanks in advance.
12-02-13, 09:33 #2Resident Curmudgeon
Provided Answers: 54
- Join Date
- Feb 2004
- In front of the computer
Active Directory logins in the form Domain\User can authenticate to any machine that is part of that Active Directory Domain, or on any machine which is part of any other domain that has a Trust Relationship with the user's domain.
Local windows logins of the form MachineName\UserName can only authenticate on the machine where they are created. This is why they are called local windows logins.
Trying to use another machine's Local Windows logins is impossible by design in current versions of Microsoft Windows, so Oracle can't use those logins the way that you've described.
-PatPIn theory, theory and practice are identical. In practice, theory and practice are unrelated.