RE: How to deny DBCC SQLPERF(logspace)

From: Michael Shao [MSFT] (v-yshao_at_online.microsoft.com)
Date: 10/30/03 

Date: Thu, 30 Oct 2003 10:38:53 GMT

Hi Yoshihiro,

Based on my experience, unfortunately, it seems that there is no way to
deny the DBCC SQLPERF (logspace) command on public role. DBCC SQLPERF
permissions default to any user. Privilege DBCC SQLPERF (logspace) may not
be granted or revoked. Thanks for your understanding.

Thanks for using MSDN newsgroup.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.