I have a SQL account with the following permissions on a database:
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
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?