Latest Technology News

Tuesday, March 20, 2012

SQL SERVER – Disable Guest Account – Serious Security Issue

How can find out if the guest user account exists?
EXEC sp_MSforeachdb 'USE [?];
SELECT * FROM sysusers;'
GO


How can remove/disable the guest user account?
USE
GO
REVOKE CONNECT FROM GUEST
GO

No comments:

Post a Comment