SYSCAT.BUFFERPOOLAUTH catalog view
Each row represents a user, group, or role that has been granted the USAGE privilege on a particular bufferpool in the database.
| Column Name | Data Type | Nullable | Updatable | Description |
|---|---|---|---|---|
| GRANTOR | VARCHAR (128) | Grantor of the privilege. | ||
| GRANTEE | VARCHAR (128) | Holder of the privilege. | ||
| GRANTORTYPE | CHAR(1) | G = Grantor is a group U = Grantor is an individual user | ||
| GRANTEETYPE | CHAR(1) | G = Grantee is a group R = Grantee is a role U = Grantee is an individual user | ||
| BUFFERPOOLID | INTEGER | Identifier for the buffer pool | ||
| BPNAME | VARCHAR(128) | Name of the buffer pool | ||
| USAGEAUTH | CHAR(1) | Privilege to use the bufferpool. N = Not held Y = Held | ||
| GRANT_TIME | TIMESTAMP | Time at which the privilege was granted |