GS_GLOBAL_CHAIN
GS_GLOBAL_CHAIN records information about modification operations performed by users on the tamper-proof user table. Each record corresponds to a table-level modification operation. Users with the audit administrator permission can query this system catalog, but no user is allowed to modify this system catalog.
| Name | Type | Description |
|---|---|---|
| blocknum | bigint | Block number, which is the sequence number of the current user operation recorded in the ledger. |
| dbname | name | Name of the database to which the modified tamper-proof user table belongs. |
| username | name | Username, which is the name of the user who performs the operation of modifying the user table. |
| starttime | timestamp with time zone | Time when a user performs an operation. |
| relid | oid | OID of the modified tamper-proof user table |
| relnsp | name | Schema name, which is the name of the schema to which the modified tamper-proof user table belongs. |
| relname | name | User table name, which is the name of the modified tamper-proof user table. |
| relhash | hash16 | Table-level hash change amount generated by operations. |
| globalhash | hash32 | Global digest, which is calculated based on the information of the current row and globalhash of the previous row. It connects the entire table to verify the integrity of GS_GLOBAL_CHAIN data. |
| txcommand | text | SQL statement whose operations are recorded. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
