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 the login should be a valid user in the target database.
