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)
Article ID: 000009075
- Legacy Products
Receive notifications and find solutions for new or common issues
Get summarized answers and video solutions from our new AI chatbot.
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App