I get the following error message in SQL Server 2005: <pre class="prettyprint"><code>User '<username>' does not have permission to run DBCC DBREINDEX for object '<table>'. </code></pre> Which minimum role do I have to give to user in order to run the command?

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

User does not have permission to run DBCC DBREINDEX

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?

334

asked Sep 11 '08 14:09

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

121

answered Nov 11 '22 05:11

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!