I have a sql account with the following permissions on a database:
The db_executor role you see this account being a member of was created by this script:
CREATE ROLE [db_executor] AUTHORIZATION [dbo] GO GRANT EXECUTE TO [db_executor] GO
When I run a select, update, insert or delete on the table, it works fine. When I try to truncate the table, it gives me this error message:
Cannot find the object "TableName" because it does not exist or you do not have permissions.
What permission is this account missing?