AUTHID

CHAR(18)

The authorization ID of the user or group that holds one or more privileges on the resource group.

RESOURCETYPE

CHAR(4)

The code for the resource group to which the privileges apply:

• 'QSCH'—SQL Schema

RESOURCENAME

CHAR(60)

The schema name.

RUNTIMEAUTH

BINARY(2)

Runtime privileges that have been granted on the schema:

• 143—ALL (ACCESS and OWNER privileges)

When a CREATE SCHEMA statement is executed, a row is inserted into SYSTEM.RESGROUPAUTH. AUTHID is the ID of the user executing the statement, and RUNTIMEAUTH is 143 (ALL). If ownership of the schema is transferred, AUTHID is modified but RUNTIMEAUTH remains 143.

RUNTIMEAUTHW

BINARY(2)

The runtime privileges a user represented by AUTHID may grant to other authorization IDs:

• 143—ALL

ALL includes schema ownership, which can be transferred, and these access privileges, which can be granted as appropriate on tables and access modules:

• SELECT
• EXECUTE
• INSERT
• UPDATE
• DELETE

DEFNAUTH

BINARY(2)

Definition privileges that have been granted on the schema and the resources associated with the schema:

• 191—ALL (DEFINE, REFERENCES, and OWNER)

DEFNAUTHW

BINARY(2)

The definition privileges a user represented by AUTHID may grant to other authorization IDs:

• 191—ALL (definition privileges, REFERENCES, and OWNER)

ALL includes schema ownership, which can be transferred, and these privileges, which can be granted as appropriate on tables and access modules:

• CREATE
• ALTER
• DROP
• DISPLAY
• USE
• REFERENCES

OTHERAUTH

BINARY(2)

(Not applicable—initialized to binary zeros.)

FUNCTIONS

BINARY(32)

(Not applicable—initialized to binary zeros.)

CTIME

TIMESTAMP

Time created.

UTIME

TIMESTAMP

Time of the last update.

CUSER

CHAR(18)

ID of the user who created the resource group authorization.

UUSER

CHAR(18)

ID of the user who last updated the resource group authorization.

FILLER

BINARY(16)

(Reserved—initialized to spaces.)