Granting the TRUNCATE Privilege on Tables
Grant the privilege to truncate a specified table.
Prerequisites
Requires one of:
The MANAGE ANY OBJECT PRIVILEGE system privilege or,
The TRUNCATE object privilege with the WITH GRANT OPTION clause on the table or,
You own the table.
Task
To grant the TRUNCATE privilege, enter:
GRANT TRUNCATE
ON
table_name
TO
userID
[,...]
Parent topic:
Grant and Revoke Object-Level Privileges
Related tasks
Granting the Right to Administer an Object-Level Privilege
Related reference
GRANT Object-Level Privilege Statement
Created December 19, 2013. Send feedback on this help topic to Technical Publications:
pubs@sap.com