Tuesday, August 11, 2020
    Home Oracle Security OSAUTH_PREFIX_DOMAIN for Oracle


    Hi friends,

    How to set OSAUTH_PREFIX_DOMAIN in Oracle database for windows security of Oracle databases.

    - Advertisement -

    Yes, we can set OSAUTH_PREFIX_DOMAIN parameter in windows registry as follows.

    Go to following windows registry of Oracle software


    And add an entry of OSAUTH_PREFIX_DOMAIN=true

    - Advertisement -

    This entry forces the external users to use the domain names in login. After enabling this entry in your server. We can create an external user as follows.

    create user “OPS$NTDOMAINusername” identified externally;

    Means if you are login as scott/tiger it becoming as your_domainscott/tiger.

    This entry will prevent OS account spoofing.

    In the Unix box, we can export the same parameter as an environment variable or add the same as a variable in .profile or .bash_profile.

    Sometimes we can get the following error due to mismatch domain name login as an external user.

    ORA-01017: invalid username/password; login denied

    Thanks and regards,

    Dbametrix Solutions

    - Advertisement -
    - Advertisment -

    Most Popular

    ASM Disk creation issue

    The article explains how to troubleshoot Oracle ASM disk creation. Solution of Oracle ASM disk creation with ASMLIB

    Oracle Tuning Basics Part-2

    This is the 2nd part of Oracle database tuning basics including depth of every aspects.

    Oracle Tuning Basics Part-1

    The article explains Oracle database performance tuning basics details.

    When you finding new job

    The article guides you 10 things to remember when you are searching a new job to improve yourself including skills and better growth for every DBA.

    Recent Comments