ERROR

Insufficient permissions (-25). Unable to truncate table

Last Published: April 25, 2020

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)

    Article ID:000009075

    Software:
    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic