SYSACCEL.SYSACCELERATEDTABLESAUTH table
The SYSACCEL.SYSACCELERATEDTABLESAUTH table records the privileges that are held by users over tables that are enabled for acceleration.
Column name | Data type | Description | Use |
---|---|---|---|
ACCELERATORNAME |
VARCHAR(128)
NOT NULL |
A unique name for the accelerator server. This is the name by which the accelerator server is known to the local Db2 accelerated query tables. | G |
GRANTOR |
VARCHAR(128)
NOT NULL |
Authorization ID of the user who granted the privilege. | G |
GRANTEE |
VARCHAR(128)
NOT NULL |
Grantee who holds the privileges to access the table in the
accelerator. Currently, only a location name for a referencing Db2 for z/OS® subsystem is supported. The location name must be the name of a Db2 for z/OS subsystem that was paired to the accelerator when the ACCEL_GRANT_TABLES_REFERENCE stored procedure granted the privilege. |
G |
GRANTEETYPE |
CHAR(1) NOT NULL
|
Indicates the type of grantee:
|
G |
TCREATOR |
VARCHAR(128)
NOT NULL |
The schema of the table. | G |
TNAME |
VARCHAR(128)
NOT NULL |
The name of the table. | G |
SELECTAUTH |
CHAR(1) NOT NULL
|
Indicates whether the GRANTEE can select rows from the table or view:
|
G |
GRANTEDTS |
TIMESTAMP
NOT NULL WITH DEFAULT |
The time when the GRANT statement was executed for the table. | G |