English

Error: Insufficient permissions (-25). Unable to truncate table

Error Message

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>."

Cause

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:
· SELECT
· UPDATE
· INSERT
· DELETE
· DROP ANY TABLE (Oracle)
· ALTER on the database (SQL Server)