Server Ku

Showing posts with label Guest User. Show all posts
Showing posts with label Guest User. Show all posts

Friday, 29 May 2015

Disable Guest User in all databases in SQL Server by serverku

As a database security, we should disable guest account from databases, You can do it with revoke access from that user.

USE yourDataBaseName
GO
REVOKE CONNECT FROM GUEST;
GO
Posted by Jason at 19:30 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: database, Guest User, revoke, script, Security, short notes, SQL, SQL Server
Older Posts Home
Subscribe to: Posts (Atom)

About Me

Jason
View my complete profile

Blog Archive

  • ▼  2016 (4)
    • ▼  August (1)
      • Email Notification for DBA Monitoring and Alerts -...
    • ►  July (1)
    • ►  May (1)
    • ►  January (1)
  • ►  2015 (121)
    • ►  November (1)
    • ►  October (2)
    • ►  September (5)
    • ►  August (5)
    • ►  July (4)
    • ►  June (12)
    • ►  May (69)
    • ►  April (23)
  • ►  2014 (2)
    • ►  April (1)
    • ►  January (1)
  • ►  2013 (25)
    • ►  October (3)
    • ►  July (2)
    • ►  April (8)
    • ►  March (1)
    • ►  February (8)
    • ►  January (3)
  • ►  2012 (13)
    • ►  December (5)
    • ►  August (1)
    • ►  February (3)
    • ►  January (4)
  • ►  2011 (20)
    • ►  December (6)
    • ►  November (6)
    • ►  October (4)
    • ►  September (4)
  • ►  2009 (1)
    • ►  March (1)
Simple theme. Powered by Blogger.