Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2013
    Posts
    2

    Unhappy Unanswered: Windows authentication from client

    Hello Wisers,
    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
    sqlplus /

    but the same command doesnt work for client machine.

    Please help!!!

    Thanks in advance.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •