Truncate Table privilege
From InterBase
Go Up to Truncate Table
Execution of a Truncate Table command requires a TRUNCATE privilege. By default, this privilege is granted only to the table owner and SYSDBA initially. The TRUNCATE privilege must be specifically granted to any other authorization identifier as it is not considered a member of ALL privileges.
{GRANT | REVOKE} TRUNCATE ON <table_name> {TO | FROM} <grantee> [WITH GRANT OPTION]
Note:
The
The
TRUNCATE privilege is not required on referencing tables with non-ON DELETE CASCADE foreign key constraints when checking if those tables are empty.[1]
- ↑ : In this context "empty" means the table has no data storage allocated to it. A table with no rows still has storage allocated to it.