Posts

Showing posts from August, 2011

Usage of OS_AUTHENT_PREFIX

1.Overview1)OS_AUTHENT_PREFIX is an important initialization parameter to configure Oracle External User environment. 2)External User is a kind of Oracle External Authentication solution. 3)With Oracle External User, the user authentication process is accomplished by operating system automatically. 4)Authorized OS user can access Oracle database directly without providing username and password other than logon with prompting these information.
2.Official ReferenceOS_AUTHENT_PREFIX Parameter type String Syntax OS_AUTHENT_PREFIX = authentication_prefix Default value OPS$ Modifiable No OS_AUTHENT_PREFIX specifies a prefix that Oracle uses to authenticate users attempting to connect to the server. Oracle concatenates the value of this parameter to the beginning of the user’s operating system account name and password. When a connection request is attempted, Oracle compares the prefixed username with Oracle usernames in the database. The default value of this parameter is OPS$ for backward compa…