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.
You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery