Hi friends,
How to set OSAUTH_PREFIX_DOMAIN in Oracle database for Windows security of Oracle databases.
Yes, we can set OSAUTH_PREFIX_DOMAIN parameter in the Windows registry as follows.
Go to the following Windows registry of Oracle software
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME#
And add an entry of OSAUTH_PREFIX_DOMAIN=true
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;
This means if you are login as scott/tiger it’s 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 a mismatch in domain name login as an external user.
ORA-01017: invalid username/password; login denied
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.