Order of precedence for database user specification

Database user login can be specified with different methods, as show in this table. Precedence order if defined from top to bottom:

Table 1. Database user login methods
Connection Instruction	FGLPROFILE	Effect
`CONNECT TO "dbname" USER "user" USING "pswd"` or `DEFINE db VARCHAR(200) LET db = "dbname+username='username', password='pswd'" DATABASE db`	N/A (ignored)	The user information in the `USER`/`USING` clause of the `CONNECT TO` instruction or in the connection string of the `DATABASE` instruction are used to identify the actual user. are used to identify the actual user. Connection string can also be used with `CONNECT TO`.
`DATABASE dbname` or `CONNECT TO "dbname"`	No specific `dbi.*` entry	No user login and password is provided to the database server. Usually, the Operating System authentication takes place.
`DATABASE dbname` or `CONNECT TO "dbname"`	`dbi.default.userauth.callback = "fx"`	Callback function `fx` is called to get user name and password when connection instruction is executed.
`DATABASE dbname` or `CONNECT TO "dbname"`	`dbi.database.dbname.username = ... dbi.database.dbname.password = ...`	The FGLPROFILE default user name and password are used to connect to the database server. Important: NOT RECOMMENDED IN PRODUCTION!