User does not have permission to run DBCC DBREINDEX

Question

I get the following error message in SQL Server 2005:

User '<username>' does not have permission to run DBCC DBREINDEX for object '<table>'.

Which minimum role do I have to give to user in order to run the command?

Answer 1

You will need to be a member of the db_ddladmin or the db_owner role AFAIK