Error: Insufficient permissions (-25). Unable to truncate table
When executing 'sdetable –o truncate' against a business table that is not owned by the user specified with the -u option, but for which sufficient privileges have been granted (SELECT, UPDATE, INSERT, and DELETE on the table, plus DROP ANY TABLE if stored in Oracle, and ALTER on the database if stored in SQL Server), the following error message occurs:
"Insufficient permissions (-25). Unable to truncate table <table_name>."
This is a known issue.
Solution or Workaround
Execute 'sdetable –o truncate' as the owner of the table or with the ArcSDE administrator login.
If using the ArcSDE administrator login, be sure this account has the following privileges on the table:
· DROP ANY TABLE (Oracle)
· ALTER on the database (SQL Server)