Permission to execute DBCC %ls denied.

Details
Product: SQL Server
Event ID: 7956
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: Permission to execute DBCC %ls denied.
   
Explanation
DBCC INPUTBUFFER permissions default to members of the sysadmin fixed server role only, who can see any SPID. Other users can see any SPID they own. Permissions are not transferable.

Note that only DBCC INPUTBUFFER will raise the above message. A permission check failure for other DBCC statements will raise message 7983, “User ‘%.*ls’ does not have permission to run DBCC %ls for database ‘%.*ls’.”

   
User Action
Any login that needs to see the INPUTBUFFER for a SPID other than its own should be added to the sysadmin fixed server role.

Related:

Leave a Reply