Usage of OSAUTH_PREFIX_DOMAIN with 11.2 version
Hi, in the v$session we need to see osuser with domain name. As per recommendation bellow I set the registry but it did not help. I will appreciate it very much if you could shed some light on this configuration parameter.
OSAUTH_PREFIX_DOMAIN
A registry setting...
Name: OSAUTH_PREFIX_DOMAIN
Type: REG_SZ
Data: TRUE | FALSE
located on the database at the following location
• 9i and earlier
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HomeX
• 10g and later
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1
or
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1
which specifies if the Domain or Machine name should be included with the OS username when using Windows Native Authentication. Modify this setting as you would any registry setting. Valid values are TRUE or FALSE. If not specified, the default is TRUE.