odbc.user

The odbc.user configuration file defines all users which are allowed to access the ODBC server if Security = odbc is configured.

The location of this file is configured in the odbc.cfg file. It may be redefined for a data source in the odbc.dsn file.

The default location is: /etc/opt/sqlr/4.0/odbc.user (on HP-UX and Linux) or odbc.user in the etc subdirectory on Windows.

Each user is a different section. The following configuration items are recognized for each section:

Name

The user name. This is currently not used by the software and is only intended for documentation.

Password

The user password in clear text. This password must be provided by the ODBC client along with the user name in order to be authorized as a legitimate user.
To avoid a clear text password the PassKey config item may be used instead.

Passkey

Refers to a password key defined in the odbc.pswd file. This is an alternative to using the Password item. The odbc.pswd file stores passwords in encrypted form and is maintained by the sqlrpasswd utility.

GroupList

List of comma-separated group names to specify the user group membership. Defined group names may be used in GroupReadList and/or GroupWriteList in the odbc.dsn file.

For example

[test]
Name      = Sample ODBC User
Password  = secret
GroupList = users,test