Tuesday, October 20, 2020
dbametrix
More
    Home Oracle Security OSAUTH_PREFIX_DOMAIN for Oracle

    OSAUTH_PREFIX_DOMAIN for Oracle

    Hi friends,

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

    - Advertisement -
    dbametrix

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

    Go to following windows registry of Oracle software

    HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME#

    And add an entry of OSAUTH_PREFIX_DOMAIN=true

    - Advertisement -
    dbametrix

    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 -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Differences Raw Device, ASM Device and CFS

    The article explains basic differences of ASM device, raw device and Oracle cluster file system cfs with fundamentals

    What is a Database Administrator?

    The blog post explains what is the work of database administrator called DBA in database domain and what is the importance.

    Top Reasons to Implement Remote Database Monitoring

    The blog post explains top three reasons and ideas to get remote monitoring services from outer support company.

    Recent Comments