Close

June 6, 2013

Truncate Requires Control Rights

Below is an output from a sql login session, the sql login account has select permissions, and attempts to truncate [quickly delete rows without logging each transaction] the table which has over 10,000 rows of data.

SQL Code

truncate tableĀ  [AdventureWorks2012].[dbo].[MyList]

Result ==========

Msg 1088, Level 16, State 7, Line 1 Cannot find the object “MyList” because it does not exist or you do not have permissions.

Solution

use [AdventureWorks2012]
GO
GRANT CONTROL ON [dbo].[MyList] TO [myuid]
GO

Result

6-5-2013 8-24-42 PM

In the above example, myuid is the name of the sql login account