B.18 Content of SQL_TABLE_PRIVILEGES

SQL_TABLE_PRIVILEGES stores information related to access privileges for tables. Each row stores one table's worth of information on one authorization identifier granted by a privilege grantor.

The following table describes the content of SQL_TABLE_PRIVILEGES.

Table B‒20: Content of SQL_TABLE_PRIVILEGES
No.	Column name	Data type	Stored information
1	`GRANTOR`	`VARCHAR(100)`	Authorization identifier of the HADB user who granted the access privilege
2	`GRANTEE`	`VARCHAR(100)`	Authorization identifier of the HADB user to whom the access privilege was granted, or `'PUBLIC'`
3	`GRANTEE_TYPE`	`CHAR(1)`	Type of HADB user to whom the access privilege was granted `'I'` Authorization identifier of the HADB user or `PUBLIC`
4	`OWNER`	`VARCHAR(100)`	Authorization identifier of the HADB user who owns the table to which the access privilege applies
5	`TABLE_SCHEMA`	`VARCHAR(100)`	Schema name of the table to which the access privilege applies
6	`TABLE_NAME`	`VARCHAR(100)`	Table identifier of the table to which the access privilege applies
7	`GRANT_TIME`	`TIMESTAMP`	Time when the access privilege was granted Stores the time when a privilege grantor granted a table access privilege to a single authorization identifier for the first time.
8	`SELECT_PRIVILEGE`	`CHAR(1)`	Whether the HADB user has the `SELECT` privilege `G` The HADB user has the `SELECT` privilege with grant option `Y` The HADB user has the `SELECT` privilege without grant option `N` The HADB user does not have the `SELECT` privilege
9	`INSERT_PRIVILEGE`	`CHAR(1)`	Whether the HADB user has the `INSERT` privilege `G` The HADB user has the `INSERT` privilege with grant option `Y` The HADB user has the `INSERT` privilege without grant option `N` The HADB user does not have the `INSERT` privilege
10	`UPDATE_PRIVILEGE`	`CHAR(1)`	Whether the HADB user has the `UPDATE` privilege `G` The HADB user has the `UPDATE` privilege with grant option `Y` The HADB user has the `UPDATE` privilege without grant option `N` The HADB user does not have the `UPDATE` privilege
11	`DELETE_PRIVILEGE`	`CHAR(1)`	Whether the HADB user has the `DELETE` privilege `G` The HADB user has the `DELETE` privilege with grant option `Y` The HADB user has the `DELETE` privilege without grant option `N` The HADB user does not have the `DELETE` privilege
12	`TRUNCATE_PRIVILEGE`	`CHAR(1)`	Whether the HADB user has the `TRUNCATE` privilege `G` The HADB user has the `TRUNCATE` privilege with grant option `Y` The HADB user has the `TRUNCATE` privilege without grant option `N` The HADB user does not have the `TRUNCATE` privilege
13	`REFERENCES_PRIVILEGE`	`CHAR(1)`	Whether the HADB user has the `REFERENCES` privilege `G` The HADB user has the `REFERENCES` privilege with grant option `Y` The HADB user has the `REFERENCES` privilege without grant option `N` The HADB user does not have the `REFERENCES` privilege
14	`IMPORT_TABLE_PRIVILEGE`	`CHAR(1)`	Whether the HADB user has the `IMPORT` `TABLE` privilege `G` The HADB user has the `IMPORT TABLE` privilege with grant option `Y` The HADB user has the `IMPORT TABLE` privilege without grant option `N` The HADB user does not have the `IMPORT TABLE` privilege
15	`REBUILD_INDEX_PRIVILEGE`	`CHAR(1)`	Whether the HADB user has the `REBUILD` `INDEX` privilege `G` The HADB user has the `REBUILD INDEX` privilege with grant option `Y` The HADB user has the `REBUILD INDEX` privilege without grant option `N` The HADB user does not have the `REBUILD INDEX` privilege
16	`GET_COSTINFO_PRIVILEGE`	`CHAR(1)`	Whether the HADB user has the `GET` `COSTINFO` privilege `G` The HADB user has the `GET COSTINFO` privilege with grant option `Y` The HADB user has the `GET COSTINFO` privilege without grant option `N` The HADB user does not have the `GET COSTINFO` privilege
17	`EXPORT_TABLE_PRIVILEGE`	`CHAR(1)`	Whether the HADB user has the `EXPORT` `TABLE` privilege `G` The HADB user has the `EXPORT TABLE` privilege with grant option `Y` The HADB user has the `EXPORT TABLE` privilege without grant option `N` The HADB user does not have the `EXPORT TABLE` privilege
18	`MERGE_CHUNK_PRIVILEGE`	`CHAR(1)`	Whether the HADB user has the `MERGE` `CHUNK` privilege `G` The HADB user has the `MERGE CHUNK` privilege with grant option `Y` The HADB user has the `MERGE CHUNK` privilege without grant option `N` The HADB user does not have the `MERGE CHUNK` privilege
19	`CHANGE_CHUNK_COMMENT_PRIVILEGE`	`CHAR(1)`	Whether the HADB user has the `CHANGE` `CHUNK` `COMMENT` privilege `G` The HADB user has the `CHANGE CHUNK COMMENT` privilege with grant option `Y` The HADB user has the `CHANGE CHUNK COMMENT` privilege without grant option `N` The HADB user does not have the `CHANGE CHUNK COMMENT` privilege
20	`CHANGE_CHUNK_STATUS_PRIVILEGE`	`CHAR(1)`	Whether the HADB user has the `CHANGE` `CHUNK` `STATUS` privilege `G` The HADB user has the `CHANGE CHUNK STATUS` privilege with grant option `Y` The HADB user has the `CHANGE CHUNK STATUS` privilege without grant option `N` The HADB user does not have the `CHANGE CHUNK STATUS` privilege
21	`ARCHIVE_CHUNK_PRIVILEGE`	`CHAR(1)`	Whether the HADB user has the `ARCHIVE` `CHUNK` privilege `G` The HADB user has the `ARCHIVE CHUNK` privilege with grant option `Y` The HADB user has the `ARCHIVE CHUNK` privilege without grant option `N` The HADB user does not have the `ARCHIVE CHUNK` privilege
22	`UNARCHIVE_CHUNK_PRIVILEGE`	`CHAR(1)`	Whether the HADB user has the `UNARCHIVE` `CHUNK` privilege `G` The HADB user has the `UNARCHIVE CHUNK` privilege with grant option `Y` The HADB user has the `UNARCHIVE CHUNK` privilege without grant option `N` The HADB user does not have the `UNARCHIVE CHUNK` privilege

Note: You cannot retrieve information about the access privileges for a viewed table if the viewed table has been invalidated.

▪ Information on access privileges for dictionary tables and system tables

Information on access privileges for dictionary tables and system tables is not stored in SQL_TABLE_PRIVILEGES. Information on access privileges for dictionary tables and system tables, is assumed to be as follows:

SELECT_PRIVILEGE (Whether the HADB user has the SELECT privilege)

'G': The HADB user has the SELECT privilege with grant option
EXPORT_TABLE_PRIVILEGE (Whether the HADB user has the EXPORT TABLE privilege)

'G': The HADB user has the EXPORT TABLE privilege with grant option
Whether the HADB user has any access privileges other than the preceding ones

N: No

To Page Top