The SQLID (also called SQL Authorization ID in DB2) is the AuthID used as the implicit qualifier for a table, view or index name in dynamic SQL statements, and for authorization checking of dynamic SQL statements. It also performs a special role as the default creator for CREATE statements, and as the grantor for GRANT statements.
Initially the SQLID is the Primary AuthID of a session. If a SecondaryID exists, the SQLID (and the Primary AuthID) is set to the SecondaryID. The SQLID in use by a particular user or process can be changed using the SET CURRENT SQLID statement, or through a Security User ExitThis applies to Windows environments (local development) only. . See Security User Exit for more information. See the SQL Reference for more information on the SET CURRENT SQLID statement. Usually the current SQLID must be the Primary AuthID, SecondaryID, or a GroupID of the session.
If security is off, the default Primary AuthID stored in the client configuration is used for internal system identification. This default can be modified through the Options Utility.