Event ID - 7956

Event Id7956
SourceMSSQLServer
DescriptionPermission to execute DBCC %ls denied.
Event InformationCAUSE:
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."

RESOLUTION:
Any login that needs to see the INPUTBUFFER for a SPID other than its own should be added to the sysadmin fixed server role.
Reference LinksMicrosoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 7956

Catch threats immediately

We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.

See what we caught

Did this information help you to resolve the problem?

Yes: My problem was resolved.
No: The information was not helpful / Partially helpful.