Choosing an authorization ID on OS/390

A QMF session is started and runs under the authorization ID of the user or program that starts the QMF session.

You can assign a single SQL authorization ID or a single primary authorization ID with one or more secondary authorization IDs.

The SQL authorization ID must be either a primary or secondary authorization ID. Both the primary and secondary IDs are fixed for the duration of the user's session.

Authorization IDs are names that contain no more than eight characters. The first character must be a letter, and the remaining seven characters can consist of letters or numbers. For rules of these names, see the DB2 UDB for OS390 SQL Reference. Authorization IDs are the source of all DB2 privileges. Each authorization ID can possess any number and any kind of DB2 privileges. For example, JONES is one of the user A's authorization IDs, and JONES has the SELECT privilege on the table SMITH.TABLEA. Thus, user A also has the SELECT privilege on SMITH.TABLEA, and can run a SELECT query on that table.