Truncate Table privilege

From InterBase
Jump to: navigation, search

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 TRUNCATE privilege is not required on referencing tables with non-ON CASCADE DELETE foreign key constraints when checking if those tables are empty.[1]


  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.

Advance To: