Conversion of User Name to Authorization Identifier

If an external authentication system is used, the conversion of the user's name to an authorization identifier does not happen until after authentication has occurred but before user authorization. Imagine, for example, a user named Fred.


Let's take a second example, where Fred has a slightly different name within the user authentication system.


As shown in the first example, your external authentication system may be case-sensitive, whereas the authorization identifier within SQLFire may not be. If your authentication system allows two distinct users whose names differ by case, delimit all user names within the connection request to make all user names case-sensitive within the SQLFire system. In addition, you must also delimit user names that do not conform to SQL92Identifier rules with double quotes.