Script Download:

This T-SQL sample script checks permissions for guest user in all databases. This script applies to system and to user databases.

Knowing about guest user in Sql server is a frequent security requirement. This can also be a source of confusion since many a times guest user is disabled in Sql Server msdb's Sql server and results in issues indicated in below mentioned KB. 

Some forums for such requirements are below: 

Such a script should also help in below mentioned KB (KB has script for single database):

You should not disable the guest user in the msdb database in SQL Server 

Script does below:

  • Script checks that all databases (except msdb) do not have any permission per security best practice.
  • Script checks that msdb database has Connect permission for guest user.
  • Script runs in Sql 2005/2008/2008R2/2012.


image image

You can find more All-In-One Script Framework script samples at