Order of precedence for database user specification
Database user login can be specified with different methods, as shown in this table. Precedence order if defined from top to bottom:
Connection Instruction | FGLPROFILE | Effect |
---|---|---|
or
|
N/A (ignored) | The user information in the / clause of
the instruction or in the connection string of the
instruction are used to identify the actual user.Connection string can also be used with . |
or
|
No specific entry |
No user login and password is provided to the database server. Usually, the Operating System authentication takes place. |
or
|
|
Callback function is
called to get user name and password when connection instruction is
executed. |
or
|
|
The FGLPROFILE default user name and password are used to connect to the database server. Important: NOT RECOMMENDED IN PRODUCTION!
|