grant dbcc and revoke dbcc work on users in databases.
Since roles are automatically added as users in a database on their first grant in a database, there are no additional requirements when roles are granted dbcc privileges. Logins must be valid users in the database where permissions are granted. Valid users include “guest.”
For server-wide dbcc commands, the login must be a valid user in master, and the System Administrator must be in master when granting the permission.
For database-specific dbcc commands:
Server-wide grants – the login must be a valid user in master. Database-level commands granted at the server level do not give access to databases where the user is not a valid user. It only avoids having to grant permission in each database separately.
Database-specific grants – the login should be a valid user in the target database.
See the Reference Manual for syntax and usage information about grant dbcc and revoke dbcc.
