OSAUTH_PREFIX_DOMAIN for Oracle

February 8, 2010 | By

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 windows registry as follows.

Go to following windows registry of Oracle software

HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME#

And add entry of OSAUTH_PREFIX_DOMAIN=true

This entry forces external user to use domain name in login. After enabling this entry in your server. We can create 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 Unix box, we can export same parameter as environment variable or add same as variable in .profile or .bash_profile.

Sometime we can get following error due to mismatch domain name login as external user.

ORA-01017: invalid username/password; login denied

Thanks and regards,
Rajesh Dave
Dbametrix Solutions

Be Sociable, Share!

Tags: , , , , , , , , ,

Category: howto, oracle security

Comments are closed.