How to verify 'Revoke Connect From Guest'

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  July 6, 2009 at 9:24 am

  #202029

  I have revoked the 'connect' permission from the guest user. How may I verify that the permission was disabled? Is there an Information_Schema View or sys table I can view to actually see that the permission was disabled? It does not show in SSMS (Object Browser or the Guest User Property Page.) We have SQL Server 2005 (SP3) running on Windows.

  Thanks in advance, Kevin

• SA-1

  SSCrazy Eights

  Points: 8113

  More actions

  July 8, 2009 at 9:22 am

  #1021783

  Run this procedure for each database except master and tempdb. You can't revoke the guest permissions in both these databases.

  SELECT dpr.name, dpr.type_desc, dpe.permission_name, dpe.state_desc

  FROM sys.database_principals dpr LEFT JOIN sys.database_permissions dpe

  ON grantee_principal_id = principal_id

  WHERE name = 'guest'