Specifies the password in clear text. The gateway simply retrieves this value and uses it as the DBMS password.

This is not secure and is recommended only for testing purposes.

Stores the password as a Name Server vnode entry. When this variation is specified, the username entry must be specified as an asterisk ("*").

On UNIX, it must be escaped with a backslash: \*

See gwsetlogin Utility in this chapter for additional information.

The Name Server vnode name is used to obtain a username/password pair that is used to access the DBMS. This entry has the following form:

The user1 variation allows a single alias entry to be authorized
for use by many gateway client users. Each user can have a different DBMS userid (or the same one). You can use NETU, NETUTIL, GWSETLOGIN, or Visual DBA to create the vnode entry. You must create the entry as either a global vnode or as a private vnode under the feuser userid. See gwsetlogin Utility in this chapter for additional information.

This form of authorization is a secure mechanism. The gateway
administrator is responsible for managing the global name server entries. The gateway administrator must have the NET_ADMIN Ingres Net permission.

Specifies that the password is stored in the Name Server under a specific vnode entry. The password is obtained from the following Name Server vnode entry:

This variation of password provides a security mechanism to allow the specification of a password without having it shown in clear text.

The gateway administrator is responsible for administering these passwords. These Name Server vnode entries must be created as global vnode entries or under the private vnode entry for the feuser (or user1 if the user is explicitly given in the username field of this entry).

This variation specifies that the password used to connect to the database is NULL. Before connecting to the database, this value is translated into a NULL value. This allows the use of the Microsoft SQL Server SA userid with a NULL password. The value NULL is a reserved value and is not case-sensitive.

Specifies a blank password. This may be used for operating system authentication or to require clients to specify a password (for example, with the -p parameter—see Gateway Catalog Parameters).