System History Tables

TiDB Cloud Lake's system history tables provide Data Governance capabilities by automatically tracking database activities for compliance, security monitoring, and performance analysis.

Available Tables

Permissions

Access Restrictions:

• Only SELECT and DROP operations are allowed
• ALTER operations are prohibited for all users
• Ownership cannot be transferred

Required Permissions:

To query system history tables, users need one of:

• GRANT SELECT ON *.* (global access)
• GRANT SELECT ON system_history.* (database access)
• GRANT SELECT ON system_history.table_name (table-specific access)

Example:

-- Create audit role for compliance team
CREATE ROLE audit_team;
GRANT SELECT ON system_history.* TO ROLE audit_team;
CREATE USER compliance_officer IDENTIFIED BY 'secure_password' WITH DEFAULT_ROLE='audit_team';
GRANT ROLE audit_team TO USER compliance_officer;

Configuration

TiDB Cloud Lake

✅ Automatically enabled - All system history tables are ready to use without any configuration.