[Script of May 17] Guest user permission check for multiple databases per security best practices


Script Download: GuestUserCheck.zip
http://gallery.technet.microsoft.com/scriptcenter/Guest-user-permission-ac9eecdb

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:
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/04940880-85c4-419a-a859-8a6bd58a18f0 

Such a script should also help in below mentioned KB (KB has script for single database):
http://support.microsoft.com/kb/2539091

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
image

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery

Comments (1)

  1. aw says:

    You amazingly come with really good posts. Thanks a lot for sharing your blog Microsoft.

    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Jatim
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20BJB
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20BNI%2046
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20BTPN%20Syariah
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20DKI
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Panin
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20PT%20Mandiri%20Tunas%20Finance
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20BRI%20Agro
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Muamalat
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20BItung
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20BursaKerja
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20CIKUPA
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20CPNS
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D3
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Depnaker
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Dokter
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Dosen
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Ekonomi
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Elektro
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Farmasi
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Garuda%20Indonesia
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Geologi
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Grafika
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Guru
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Hotel
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Hukum
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Indomart
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20IT
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Jobsdb
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Jobstreet
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20K3
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Kehutanan
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Kernet
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Kesehatan
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Komputer
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20BUMN
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Terbaru
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20SMA
    http://www.lokerjobindo.com
    http://www.yacinta.com
    http://www.kerjabumn.com
    http://www.wisatasia.id/search/label/Wisata-Indonesia

    http://www.wisatasia.id