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.
You have been granted the TRUNCATE object privilege with the WITH GRANT OPTION clause on the table.
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 May 23, 2013. Send feedback on this help topic to Technical Publications:
pubs@sybase.com