Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  locking down public and guest accounts

Author  Topic  dmaniac Starting Member 3 Posts Posted - 2007-02-20 : 14:26:36 I'm trying to COMPLETELY!! lock down the guest & public accounts so that when I create a new user (without any privledges what so ever) that new user can't access anything. The problem I see is that no matter what I do, the new user can still access certain system tables in the master database. I don't want anyone having access to the master database what so ever. Here is what I did to lock down both accounts. I denied all from both the guest and puclic accounts, then revoke connect from the guest account, then I disabled the guest account in the computer management console in administrative tools. Am I doing something wrong? EXEC sp_MSforeachdb 'use deny all from guest' EXEC sp_MSforeachdb 'use deny all from public' EXEC sp_MSforeachdb 'use if db_id() not between 1 and 2 begin REVOKE CONNECT FROM GUEST end'