What DBCC permissions are required? (4232232)

サポートと今すぐチャット

戻る

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

タイトル

What DBCC permissions are required?
説明

When trying to use AUTO OPTIMIZE on a SELECT, the following error is given:
"Error occured during browsing data from database.
The DBCC permission was denied on the object '1371151930', database "AH0PD01', schema 'dbo'. "
The query itself runs without any problems. What are the DBCC permissons? And how are they granted?
原因

Optimizer needs these permissions to retrieve table statistic via the SQL Server DBCC command.
対策

WORKAROUND:
Please grant the schema these permissions. Below are the DBCC commands that QSOSS will execute and their required DB privileges.
DBCC SHOWCONTIG - User must be a member of one of the following roles, sysadmin fixed server role, db_owner fixed database role or db_ddladmin fixed database role
DBCC SHOW_STATISTICS - User must be a member of one of the following roles, sysadmin fixed server role, db_owner fixed database role or db_ddladmin fixed database role
DBCC AUTOPILOT - User must be a member of the sysadmin fixed server role and requires SQL Server 2005 or later.
Please check with the SQL Server DBA.
STATUS:
Waiting for fix in a future version of Quest SQL Optimizer for SQL Server.
Defect ID

ST82364

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

推奨コンテンツ

タイトル