Library /sys$common/syshlp/SQL$HELP72.HLB  —  ATTACH  Arguments  literal-user-auth
    Specifies the user name and password to enable access to
    databases, particularly remote databases

    This literal lets you explicitly provide user name and password
    information in the attach expression.

    When you use Oracle Rdb for OpenVMS to attach to a database in
    the same cluster, you do not have to explicitly specify the user
    name and password. Oracle Rdb implicitly authenticates the user
    whenever the user attaches to a database.

    However, when you use Oracle Rdb for OpenVMS to attach to a
    database on a remote node, you must use one of the methods
    provided by Oracle Rdb to access the database.

    You can use one of the following methods to attach to a database
    on a remote OpenVMS node.

    o  Explicitly provide the user name and password in the ATTACH
       statement.

    o  Explicitly provide the user name and password in the
       configuration file RDB$CLIENT_DEFAULTS.DAT. The following
       example shows how to include the information in the
       configuration file:

       ! User name to be used for authentication
       SQL_USERNAME   HELENG

       ! Password to be used for authentication
       SQL_PASSWORD  MYPASSWORD

    o  Use a DECnet proxy account on the remote system system.

    o  Embed the user name and password in the file specification.

    o  Use the RDB$REMOTE default account.

    For information on proxy accounts, embedding the user name in
    the file specification or using the RDB$REMOTE account, see the
    Oracle Rdb Guide to SQL Programming.
Close Help