Pitney Bowes MapInfo Professional User Manual
Page 199
exists. If so, the user will connect. All references to a user authenticated by the Operating System must
include the prefix, OPS$, as seen in the example OPS$tsmith.
The default value of this parameter is OPS$ for backward compatibility with previous versions of Oracle
databases. However, you might prefer to set the prefix value to some other string or a null string (an
empty set of double quotes: " "). Using a null string eliminates the addition of any prefix to operating
system account names, so that Oracle user names exactly match operating system user names.
After you set OS_AUTHENT_PREFIX, it should remain the same for the life of a database. If you change
the prefix, then any database user name that includes the old prefix cannot be used to establish a
connection, unless you alter the user name to have it use password authentication.
Creating a User who is Authenticated by the Operating System
The following statement creates a user who is identified by Oracle and authenticated by the operating
system or a network service. This example assumes that OS_AUTHENT_PREFIX = "".
CREATE USER scott IDENTIFIED EXTERNALLY;
Using CREATE USER <user name> IDENTIFIED EXTERNALLY, you create database accounts that
must be authenticated by the operating system or network service. Oracle will then rely on this external
login authentication when it provides that specific operating system user with access to the database
resources of a specific user.
See the Oracle Database Advanced Security Administrator's Guide
(
for more information about
external authentication.
199
MapInfo Professional User Guide
Chapter 7: Working with Data in a DBMS