In SQL Server 2005, you receive the following error message:
User '<username>' does not have permission to run DBCC DBREINDEX for object '<table>'.
What is the minimum role I need to give a user to run a command?
You need to be a member of the db_ddladmin or db_owner AFAIK roles
Caller must own the table or be a member of the sysadmin fixed server role, the db_owner fixed database role, or the db_ddladmin fixed database role.
DBCC DBREINDEX (Transact-SQL) @MSDN
ALTER AUTHORIZATION ON Tablename TO [domain name \ username]