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.