I have a stored procedure that is called by users with DataReader and DataWriter rights. This stored procedure is used in the monthly closing for this company. It removes all of the records from the PaidOuts table and then needs to reset the Identity Seed to 0.

When we went live I used:

Code:
DBCC CHECKIDENT ('PaidOuts', RESEED , 0)
However, that gave an error stating that the user did not have enough permissions on the table.

I then changed the code to:

Code:
TRUNCATE TABLE PaidOuts
This, too, gave me the same message. What permissions would be needed to execute one of these statements?

Is there any way to have a DataReader/DataWriter user reset the Identity seed for a table?