Was this helpful?
Password Parameter Variation Table
The following table describes how the gateway handles variations for the password parameter.
Variation
password Parameter
pass1
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 ("*").
Note:  To specify the asterisk on the command line with gwalias, it must be surrounded by double quotes:
gwalias oracle empty_alias host "*" "*"
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:
ServerClass_dbalias_user1
ServerClass–Specifies the specific server associated with this entry. The allowed values, which correspond to the first three characters of each respective server class, are:
mss
ora
odbc
dbalias–The value of the alias dbalias entry.
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.
@vnode
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:
vnode
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).
NULL
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.
blank
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).
Note:  To specify a blank password on the command line with gwalias, it must be surrounded by double quotes:
gwalias oracle empty_alias host "" ""
Last modified date: 08/22/2022